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