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 votes191 views1 answer
Guid to string sql
SQL
0 vote199 views1 answer
Sql date time query find
SQL
0 vote199 views1 answer
Query builder doctrien return sql
SQL
4 votes177 views1 answer
Psql get sequences
SQL
1 vote192 views1 answer
How to transfer pandas datafra,e to sqlite
SQL
1 vote179 views1 answer
Oracle difference between two dates in years
SQL
15 votes181 views2 answers
How to drop database name in postgresql
SQL
18 votes176 views6 answers
Creating table in MySQL
SQL
24 votes203 views6 answers
Alter table name sql
SQL
0 vote221 views1 answer
Alter fedora mysql 8.0 user
SQL