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

Grants ORACLE

SELECT * FROM DBA_SYS_PRIVS WHERE GRANTEE LIKE 'FABIANO'

Source: blog.fabianobento.com.br

Similar codes

0 vote328 views1 answer
Laravel eloquent get generated sql
SQL
9 votes345 views1 answer
Mysql check date range
SQL
4 votes368 views1 answer
Ms sql truncate table vs delete
SQL
0 vote331 views1 answer
Mysql query single row
SQL
0 vote376 views1 answer
Pl sql disable trigger
SQL
0 vote335 views1 answer
Import big data to mysql
SQL
8 votes335 views1 answer
Oracle tablespace datafile max size
SQL
0 vote650 views1 answer
How to connect .sql data set to powerbi
SQL
1 vote333 views1 answer
Mysql copy table1 to table2
SQL
0 vote368 views1 answer
Print hello world in plsql
SQL