User Query

Hi Everyone,

Can anyone tell me how to query the roles and system privileges of the individual (or all) schemas in an Oracle database instance?

I know I could look through the manuals, but I'm short on time at the moment.

Thanks
Peer

DBA_SYS_PRIVS
DBA_ROLE_PRIVS

Thanks for the help, just what I was looking for.
Sorry about the late reply, but I got distracted.
Bye
Peer

Aargh! I just noticed that there's something missing.

I was also hoping for a query or the data dictionary views that also show me the object priviledges granted from one schema to another.

Sorry I was unclear about that.

Bye
Peer

DBA_TAB_PRIVS

Big smiles!
Thank you.