-
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
Last edited by Peer Jones; 06-17-2004 at 01:57 AM.
-
DBA_SYS_PRIVS
DBA_ROLE_PRIVS
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
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
-
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|