diff options
| author | Christian Cleberg <hello@cleberg.net> | 2024-12-28 11:30:03 -0600 |
|---|---|---|
| committer | Christian Cleberg <hello@cleberg.net> | 2024-12-28 11:30:03 -0600 |
| commit | 2ee3e7af7b9133da946dff2643505a3d7013b3c0 (patch) | |
| tree | 30159ba605abc870507902bcbc53bf6733487476 /databases/administrators/oracle_admins.sql | |
| parent | be74e8cab3bbd8b702adce0127cec2bb48dd7b7b (diff) | |
| download | audit-tools-2ee3e7af7b9133da946dff2643505a3d7013b3c0.tar.gz audit-tools-2ee3e7af7b9133da946dff2643505a3d7013b3c0.tar.bz2 audit-tools-2ee3e7af7b9133da946dff2643505a3d7013b3c0.zip | |
restructure directories
Diffstat (limited to 'databases/administrators/oracle_admins.sql')
| -rw-r--r-- | databases/administrators/oracle_admins.sql | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/databases/administrators/oracle_admins.sql b/databases/administrators/oracle_admins.sql new file mode 100644 index 0000000..bac5934 --- /dev/null +++ b/databases/administrators/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); |