diff options
| author | Christian Cleberg <hello@cleberg.net> | 2025-05-06 21:31:46 -0500 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2025-05-06 21:31:46 -0500 |
| commit | 95bf612c338dec8235e89ca6a1d9e5e8cad3f997 (patch) | |
| tree | 82cfd62fb145b7b686d4ae825ab2c2436343e590 /databases/oracle | |
| parent | d62f25007470fe546e0f9d2e38a26e84146f72c5 (diff) | |
| download | audit-tools-95bf612c338dec8235e89ca6a1d9e5e8cad3f997.tar.gz audit-tools-95bf612c338dec8235e89ca6a1d9e5e8cad3f997.tar.bz2 audit-tools-95bf612c338dec8235e89ca6a1d9e5e8cad3f997.zip | |
reorganize db dir (#6)
Diffstat (limited to 'databases/oracle')
| -rw-r--r-- | databases/oracle/oracle_admins.sql | 15 | ||||
| -rw-r--r-- | databases/oracle/oracle_admins_alt.sql | 4 |
2 files changed, 19 insertions, 0 deletions
diff --git a/databases/oracle/oracle_admins.sql b/databases/oracle/oracle_admins.sql new file mode 100644 index 0000000..bac5934 --- /dev/null +++ b/databases/oracle/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); diff --git a/databases/oracle/oracle_admins_alt.sql b/databases/oracle/oracle_admins_alt.sql new file mode 100644 index 0000000..4486829 --- /dev/null +++ b/databases/oracle/oracle_admins_alt.sql @@ -0,0 +1,4 @@ +SELECT ** FROM sys.dba_role_privs; +SELECT ** FROM sys.dba_sys_privs; +SELECT ** FROM sys.dba_tab_privs; +SELECT ** FROM sys.dba_users; |