Privileges Audited in database: - Oracle Database Script.
col user_name
FOR a12 heading "User name" col privilege
FOR a30 heading "Privilege"
SET pages 1000 prompt prompt SYSTEM PRIVILEGES audited across SYSTEM
SELECT user_name,
privilege,
success,
failure
FROM dba_priv_audit_opts
ORDER BY user_name,
proxy_name,
privilege /