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
Printable View
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.