OraFAQ Forum: Security » how to get which user grant system priv. to public

Home » RDBMS Server » Security » how to get which user grant system priv. to public (Oracle 10gR2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to get which user grant system priv. to public [message #334799]

Fri, 18 July 2008 01:08

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.

Report message to a moderator

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

Michel Cadot
Messages: 68775
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Previous Topic:	Oracle Profile
Next Topic:	What's a default role in dba_role_privs?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Mar 27 05:34:57 CDT 2026