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

4 votes160 views2 answers
DB::transaction
SQL
6 votes169 views1 answer
To count number of rows in SQL table
SQL
0 vote163 views1 answer
Oracle execute package dblink
SQL
15 votes323 views2 answers
How to sort names in alphabetical order in sql
SQL
1 vote147 views4 answers
Psql: error: FATAL: database "odoo" does not exist
SQL
49 votes221 views6 answers
Get duplicate records in sql
SQL
13 votes150 views2 answers
Sql join
SQL
0 vote144 views1 answer
Pl sql turn off variable substitution
SQL
0 vote138 views1 answer
Changer un mot de passe mysql
SQL
0 vote110 views2 answers
Sql update from two different database
SQL