sententia
Home    Blog

How to find the privileges and roles granted to a user in Oracle

DBA don't grant us rights anymore to dictionary for us to easily see the user info  (SELECT ANY DICTIONARY privilege)
 
If you log in as the user you can run these

SELECT * FROM USER_ROLE_PRIVS

select * from USER_SYS_PRIVS

select * from USER_TAB_PRIVS

 

The dba tables seem to be these:  

SELECT * FROM dba_ROLE_PRIVS
select * from dba_SYS_PRIVS
select * from dba_TAB_PRIVS