Account Aggregation

SELECT Permission

GRANT SELECT ON dba_users TO ${UserName}; (By this command discovering schema is possible)

GRANT SELECT ON dba_sys_privs TO ${UserName};

GRANT SELECT ON dba_role_privs TO ${UserName};

Note
To view Sysdba privileges: SELECT * FROM V$PWFILE_USERS

For the CDB service account, the above permissions must be in the following format:

GRANT SELECT ON dba_users TO <C##username> container=CURRENT;