blob: 3afa2e764f9379c433d392537b2709604045ae72 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
|
# `oracle_admins.sql`
``` 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);
```
``` 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 |
```
# `oracle_admins_alt.sql`
``` sql
SELECT ** FROM sys.dba_role_privs;
SELECT ** FROM sys.dba_sys_privs;
SELECT ** FROM sys.dba_tab_privs;
SELECT ** FROM sys.dba_users;
```
``` 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 |
```
|
