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