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

Similar codes

1 vote207 views2 answers
Sql where is not number
SQL
0 vote187 views1 answer
NLS_NCHAR_CHARACTERSET
SQL
13 votes217 views2 answers
Sql online compiler
SQL
0 vote195 views1 answer
Change database name psql 8
SQL
0 vote214 views1 answer
Postegresql update to null
SQL
0 vote226 views1 answer
Postgres copy command
SQL
0 vote203 views1 answer
Mariadb mysql root access denied
SQL
13 votes206 views5 answers
Sql default
SQL
12 votes192 views2 answers
Insert multiple rows from another table sql
SQL
61 votes1.2K views6 answers
Mysql add column
SQL