Query to determine which privileges, grants, roles, and tablespace quotas are granted to the users

 

SET lines 120 pages 100 select * from DBA_ROLE_PRIVS where GRANTEE = 'SIVA'; select * from DBA_SYS_PRIVS where GRANTEE = 'SIVA'; select * from DBA_TAB_PRIVS where GRANTEE = ‘SIVA’'; select * from  dba_ts_quotas where username = 'SIVA';