Oracle list user grants

-- 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';

Similar codes

12 votes292 views4 answers
How to check mysql version ubuntu
SQL
14 votes278 views4 answers
Remove record from table sql
SQL
10 votes280 views2 answers
Sql pagination offset
SQL
-1 vote266 views3 answers
SQL to LINQ converter
SQL
61 votes429 views6 answers
Mysql add column
SQL
0 vote278 views1 answer
C# get sql min date
SQL
1 vote263 views1 answer
Moodle query first user access
SQL
2 votes311 views1 answer
How to check if a row is null in sql
SQL
1 vote265 views1 answer
Jooq convert using gbk
SQL
2 votes269 views1 answer
Illuminate\Database\QueryException : SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'
SQL