diff options
| author | Christian Cleberg <hello@cleberg.net> | 2024-10-19 11:31:35 -0500 |
|---|---|---|
| committer | Christian Cleberg <hello@cleberg.net> | 2024-10-19 11:31:35 -0500 |
| commit | 40e83f1fc335c62aa2de8e7c55d62d65df08add9 (patch) | |
| tree | 080411d072d8d5af051a93c0010f7e9235284b77 /db_admins/oracle_admins.sql | |
| parent | c588eff5bd05c7d10bbc76d9971dde514118c5ee (diff) | |
| download | audit-tools-40e83f1fc335c62aa2de8e7c55d62d65df08add9.tar.gz audit-tools-40e83f1fc335c62aa2de8e7c55d62d65df08add9.tar.bz2 audit-tools-40e83f1fc335c62aa2de8e7c55d62d65df08add9.zip | |
add database admin tools
Diffstat (limited to 'db_admins/oracle_admins.sql')
| -rw-r--r-- | db_admins/oracle_admins.sql | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/db_admins/oracle_admins.sql b/db_admins/oracle_admins.sql new file mode 100644 index 0000000..bac5934 --- /dev/null +++ b/db_admins/oracle_admins.sql @@ -0,0 +1,15 @@ +SELECT + grantee AS "User", + privilege AS "Privilege" +FROM + dba_sys_privs +WHERE + grantee IN (SELECT DISTINCT grantee FROM dba_sys_privs) +UNION ALL +SELECT + grantee AS "User", + privilege AS "Privilege" +FROM + dba_tab_privs +WHERE + grantee IN (SELECT DISTINCT grantee FROM dba_tab_privs); |