Re: system privilege

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

SELECT object_name
FROM all_objects
WHERE object_name LIKE '%PRIV%';

The source of all knowledge is there.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)