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 vote159 views2 answers
Begin transaction in sql
SQL
2 votes168 views1 answer
Grant revoke privileges to mysql username
SQL
0 vote171 views1 answer
Google cloud sql postgres url example
SQL
-1 vote157 views8 answers
Create Trigger in phpMyAdmin
SQL
0 vote158 views1 answer
My sql data file extention
SQL
52 votes730 views6 answers
Rename column sql
SQL
1 vote106 views1 answer
Mssql string length
SQL
1 vote180 views1 answer
How do you use sql in you company
SQL
29 votes161 views6 answers
Delete all rows from table mysql
SQL
25 votes162 views5 answers
Date in mysql
SQL