audit-labs/audit-tools

A collection of scripts, queries, and other goodies you can use in an audit.

clone: git clone https://gitbay.org/audit-labs/audit-tools.git

main: databases/oracle/oracle_admins.sql · raw

 1SELECT
 2    grantee AS "User",
 3    privilege AS "Privilege"
 4FROM
 5    dba_sys_privs
 6WHERE
 7    grantee IN (SELECT DISTINCT grantee FROM dba_sys_privs)
 8UNION ALL
 9SELECT
10    grantee AS "User",
11    privilege AS "Privilege"
12FROM
13    dba_tab_privs
14WHERE
15    grantee IN (SELECT DISTINCT grantee FROM dba_tab_privs);