https://docs.oracle.com/cd/B19306_01/network.102/b14266/admusers.htm#i1006107 Accessing Objects in the SYS Schema

Users with explicit object privileges or those who connect with administrative privileges (SYSDBA) can access objects in the SYS schema. Another means of allowing access to objects in the SYS schema is by granting users any of the following roles:

SELECT_CATALOG_ROLE

This role can be granted to users to allow SELECT privileges on data dictionary views.

EXECUTE_CATALOG_ROLE

This role can be granted to users to allow EXECUTE privileges for packages and procedures in the data dictionary.

DELETE_CATALOG_ROLE

This role can be granted to users to allow them to delete records from the system audit table (AUD$).

Additionally, the following system privilege can be granted to users who require access to tables created in the SYS schema:

SELECT ANY DICTIONARY

This system privilege allows query access to any object in the SYS schema, including tables created in that schema. It must be granted individually to each user requiring the privilege. It is not included in GRANT ALL PRIVILEGES, but it can be granted through a role.

Caution: You should grant these roles and the SELECT ANY DICTIONARY system privilege with extreme care, because the integrity of your system can be compromised by their misuse.