Error when compiling code that includes a select statement querying a view in SYS schema: "PLS-00201 identifier 'SYS.<view>' must be declared". The SYS view can be queried outside of code as a standalone query. The SELECT_CATALOG_ROLE role is granted to user.
Insufficient Oracle rights when accessing SYS views in PL/SQL code.
In Oracle 9i and higher, grant Select Any Dictionary system privilege to user. In Oracle database previous to 9i, the only known privilege is to issue this grant logged as a SYSDBA: Grant select on <view> to <user>.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy