Home » RDBMS Server » Security » how to get which user grant system priv. to public (Oracle 10gR2)
how to get which user grant system priv. to public [message #334799] Fri, 18 July 2008 01:08 Go to next message
kukreja
Messages: 33
Registered: February 2007
Member
Hi

Is there any dictionary view or procedure to know which user had granted a particular system privilege to public.

For Example:

Sys granted a system privilege to user SCOTT
Grant alter session to scott with admin option


And Scott granted the same privilege to public
grant alter session to public


So later how can I track out which user has granted this particular privilege(alter session) to public.
Re: how to get which user grant system priv. to public [message #334801 is a reply to message #334799] Fri, 18 July 2008 01:18 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Is there any dictionary view or procedure to know which user had granted a particular system privilege to public.

No.
If you want to know this you have to audit GRANT statements.

Regards
Michel
Previous Topic: Oracle Profile
Next Topic: What's a default role in dba_role_privs?
Goto Forum:
  


Current Time: Thu Mar 28 13:03:11 CDT 2024