Oracle 23c New Features for DBA'sHello,
There were the cases of denying "select any dictionary" privilege from database security teams especially in banking section since this privilege can access the sensitive views like DEFAULT_PWD$ etc.
From 12c Onwards the "select any dictionary" system privilege no longer permits you to query the SYS schema system tables DEFAULT_PWD$, ENC$, LINK$, USER$, USER_HISTORY$, CDB_LOCAL_ADMINAUTH$, and XS$VERIFIERS. Only user SYS has access to these tables, but user SYS can grant object privileges (such as GRANT SELECT ON USER$ TO sec_admin) to other users.
So be aware when you do upgrade to 12c and your application user has granted this privilege for example to view the user$ table, now the user cannot access the same. So you have to manually provide the privilege if required.
-Thanks
Geek DBAGeek DBA
Follow Me!!!