From b598a79d270b3a91b0e6d5f3b9dca4aecca2dd4c Mon Sep 17 00:00:00 2001 From: Christian Cleberg Date: Sat, 2 Aug 2025 13:02:43 -0500 Subject: fix: convert README.org to README.md --- databases/oracle/README.org | 81 --------------------------------------------- 1 file changed, 81 deletions(-) delete mode 100644 databases/oracle/README.org (limited to 'databases/oracle/README.org') diff --git a/databases/oracle/README.org b/databases/oracle/README.org deleted file mode 100644 index f2bc680..0000000 --- a/databases/oracle/README.org +++ /dev/null @@ -1,81 +0,0 @@ -* =oracle_admins.sql= - -#+begin_src sql -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); -#+end_src - -#+begin_src text -| User | Privilege | -|----------+---------------------| -| SCOTT | CREATE SESSION | -| SCOTT | CREATE TABLE | -| SCOTT | SELECT | -| SCOTT | INSERT | -| HR | CREATE SESSION | -| HR | SELECT | -| HR | INSERT | -| HR | UPDATE | -| SYS | CREATE USER | -| SYS | GRANT ANY PRIVILEGE | -| SYS | DROP USER | -| SYSTEM | CREATE TABLESPACE | -| SYSTEM | CREATE USER | -| SYSTEM | ALTER USER | -| SYSTEM | DROP USER | -| APP_USER | SELECT ON EMPLOYEES | -| APP_USER | INSERT ON EMPLOYEES | -| APP_USER | UPDATE ON EMPLOYEES | -#+end_src - -* =oracle_admins_alt.sql= - -#+begin_src sql -SELECT ** FROM sys.dba_role_privs; -SELECT ** FROM sys.dba_sys_privs; -SELECT ** FROM sys.dba_tab_privs; -SELECT ** FROM sys.dba_users; -#+end_src - -#+begin_src text -| Grantee | Granted_Role | Admin_Option | -|----------+--------------+--------------| -| SCOTT | DBA | NO | -| HR | RESOURCE | YES | -| APP_USER | DATA_ANALYST | NO | - -| Grantee | Privilege | -|---------+---------------------| -| SCOTT | CREATE SESSION | -| HR | CREATE TABLE | -| SYS | GRANT ANY PRIVILEGE | -| SYSTEM | CREATE USER | - -| Grantee | Table_Name | Privilege | -|----------+-------------+-----------| -| SCOTT | EMPLOYEES | SELECT | -| SCOTT | EMPLOYEES | INSERT | -| HR | DEPARTMENTS | SELECT | -| APP_USER | EMPLOYEES | UPDATE | - -| Username | Account_Status | Default_Tablespace | Temporary_Tablespace | -|----------+----------------+--------------------+----------------------| -| SCOTT | OPEN | USERS | TEMP | -| HR | OPEN | USERS | TEMP | -| SYS | OPEN | SYSTEM | TEMP | -| SYSTEM | OPEN | SYSTEM | TEMP | -| APP_USER | OPEN | USERS | TEMP | -#+end_src -- cgit v1.2.3-70-g09d2