diff options
Diffstat (limited to 'databases/administrators/oracle')
-rw-r--r-- | databases/administrators/oracle/oracle_admins.sql | 15 | ||||
-rw-r--r-- | databases/administrators/oracle/oracle_admins_alt.sql | 4 |
2 files changed, 0 insertions, 19 deletions
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; |