Oracle Version: 11.2
This question is only about System Privileges .
I gather that, for a standard business user (a non SYS/SYSTEM user) , the dictionary views available to determine the priviles granted to him are
USER_SYS_PRIVS and ROLE_SYS_PRIVS .
USER_SYS_PRIVS will only show system privileges granted directly
ROLE_SYS_PRIVS will show role names along with the privileges (role_sys_privs.privilege column).
To see all the system privileges granted to a logged in user , the user has to do a UNION like.
select privilege from user_sys_privs
union
select privilege From role_sys_privs
Am I right ?
Is there a single dictionary view available to a business user by which he can see all the system privilege granted to him/her?