We help IT Professionals succeed at work.

Need data dictionary view to all the built in system privileges in oracle

Hi Team,

Can anyone help me with how to various built in  system privileges available in oracle 12c. Is there any data dictionary view which provides the information.
Comment
Watch Question

Most Valuable Expert 2012
Distinguished Expert 2019
Commented:

If you are asking what privileges are available, I would start in the docs:

https://docs.oracle.com/en/database/oracle/oracle-database/12.2/dbseg/configuring-privilege-and-role-authorization.html#GUID-C48021EF-6AEA-427F-95B2-37EFCFEA2400


SYSDBA and SYSOPER Privileges for Standard Database Operations
SYSBACKUP Administrative Privilege for Backup and Recovery Operations
SYSDG Administrative Privilege for Oracle Data Guard Operations
SYSKM Administrative Privilege for Transparent Data Encryption
SYSRAC Administrative Privilege for Oracle Real Application Clusters




Most Valuable Expert 2011
Top Expert 2012

Commented:
how about this...

SELECT DISTINCT privilege
  FROM dba_sys_privs;
Thanks a lot . You guys are awesome