Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: system privilege
For system privs, look at DBA_SYS_PRIVS. For table privs, look at
DBA_TAB_PRIVS. For roles, look at DBA_ROLE_PRIVS.
HTH,
Brian
Jenny Wang wrote:
>
> How to find out when system privilege has been granted to a schema? For
> instance, I need to know when "audit any" and "audit system" privilege has
> been granted to Bob. Thanks in advance!
>
> Jenny
-- =================================================================== Brian Peasland dba_at_remove_spam.peasland.com Remove the "remove_spam." from the email address to email me. "I can give it to you cheap, quick, and good. Now pick two out of the three"Received on Mon Jul 14 2003 - 10:26:17 CDT