From 95bf612c338dec8235e89ca6a1d9e5e8cad3f997 Mon Sep 17 00:00:00 2001 From: Christian Cleberg Date: Tue, 6 May 2025 21:31:46 -0500 Subject: reorganize db dir (#6) --- databases/administrators/oracle/oracle_admins.sql | 15 --------------- databases/administrators/oracle/oracle_admins_alt.sql | 4 ---- 2 files changed, 19 deletions(-) delete mode 100644 databases/administrators/oracle/oracle_admins.sql delete mode 100644 databases/administrators/oracle/oracle_admins_alt.sql (limited to 'databases/administrators/oracle') diff --git a/databases/administrators/oracle/oracle_admins.sql b/databases/administrators/oracle/oracle_admins.sql deleted file mode 100644 index bac5934..0000000 --- a/databases/administrators/oracle/oracle_admins.sql +++ /dev/null @@ -1,15 +0,0 @@ -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/administrators/oracle/oracle_admins_alt.sql b/databases/administrators/oracle/oracle_admins_alt.sql deleted file mode 100644 index 4486829..0000000 --- a/databases/administrators/oracle/oracle_admins_alt.sql +++ /dev/null @@ -1,4 +0,0 @@ -SELECT ** FROM sys.dba_role_privs; -SELECT ** FROM sys.dba_sys_privs; -SELECT ** FROM sys.dba_tab_privs; -SELECT ** FROM sys.dba_users; -- cgit v1.2.3-70-g09d2