Oracle privileges users

Oracle user privileges

-- List privileges, including roles, for my_user
SELECT GRANTEE, PRIVILEGE AS PRIVILEGE_ROLE,
       NULL AS OWNER, NULL AS TABLE_NAME, NULL AS COLUMN_NAME,
       ADMIN_OPTION AS PRIVILEGE, 
       NULL AS GRANTABLE
FROM DBA_SYS_PRIVS WHERE GRANTEE = 'my_user'
UNION ALL
SELECT r.GRANTEE, r.GRANTED_ROLE AS PRIVILEGE_ROLE, p.OWNER, p.TABLE_NAME, 
	p.COLUMN_NAME, PRIVILEGE, p.GRANTABLE
FROM DBA_ROLE_PRIVS r LEFT JOIN ROLE_TAB_PRIVS p ON p.ROLE = r.GRANTED_ROLE
WHERE r.GRANTEE = 'my_user';

Oracle privileges users

SELECT USERNAME,
       LOCK_DATE,
       EXPIRY_DATE
FROM DBA_USERS
WHERE USERNAME IN (SELECT GRANTEE
                   FROM DBA_SYS_PRIVS
                   WHERE PRIVILEGE = 'UNLIMITED TABLESPACE')
ORDER BY USERNAME;

Similar codes

2 votes105 views1 answer
Postgresql change value in column
SQL
0 vote121 views1 answer
Mysql workbench download for iinux mint 19.3
SQL
1 vote109 views1 answer
Postgresql substring last
SQL
28 votes116 views6 answers
Mysql change user password
SQL
1 vote132 views1 answer
Last 24 HOUR data in mysql
SQL
8 votes158 views2 answers
Default sql server port
SQL
14 votes120 views4 answers
Sql compiler
SQL
16 votes132 views6 answers
Your connection attempt failed for user 'root' to the mysql server at localhost 3306
SQL
1 vote117 views1 answer
Oracle drop temporary table
SQL
10 votes112 views5 answers
Create table mysql query
SQL