aboutsummaryrefslogtreecommitdiff
path: root/databases/administrators/oracle
diff options
context:
space:
mode:
Diffstat (limited to 'databases/administrators/oracle')
-rw-r--r--databases/administrators/oracle/oracle_admins.sql15
-rw-r--r--databases/administrators/oracle/oracle_admins_alt.sql4
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;