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

Similar codes

1 vote131 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL
3 votes130 views2 answers
Truncate table
SQL
0 vote123 views1 answer
Default column value in sql same as other column
SQL
0 vote141 views2 answers
SQLSTATE[HY000]: General error: 3780 Referencing column 'role_id' and referenced column 'id' in foreign key constraint 'user_role_id foreign' are incompatible.
SQL
4 votes140 views1 answer
Oracle nls_date_format
SQL
0 vote141 views1 answer
Vbscript clean up ADODB.Recordset
SQL
2 votes145 views1 answer
Oracle apex who is connected
SQL
0 vote127 views1 answer
Postgres list tables and row counts
SQL
2 votes131 views2 answers
Postgresql get table names
SQL
0 vote131 views1 answer
Sql row number in result set
SQL