OraFAQ Forum: Security » Script to list users with select on v$views

Home » RDBMS Server » Security » Script to list users with select on v$views

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

Script to list users with select on v$views [message #441065]

Thu, 28 January 2010 08:25

firefly
Messages: 53
Registered: March 2009
Location: Europe

Member

Hi,

Anyone have a script where I can display users with select permissions on the various v$views?
Tx
F

Report message to a moderator

Re: Script to list users with select on v$views [message #441068 is a reply to message #441065]

Thu, 28 January 2010 08:38

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

Senior Member
Account Moderator

Query DBA_TAB_PRIVS

Regards
Michel

Report message to a moderator

Re: Script to list users with select on v$views [message #441069 is a reply to message #441065]

Thu, 28 January 2010 08:46

firefly
Messages: 53
Registered: March 2009
Location: Europe

Member

Thanks - it was v_$ and not v$ (which I queried).

How come v_$instance is displayed in dba_tab_privs when it's a view?

Also, how do you display users with select permissions on a regular view?

Thanks

F

Report message to a moderator

Re: Script to list users with select on v$views [message #441070 is a reply to message #441065]

Thu, 28 January 2010 08:52

cookiemonster
Messages: 13960
Registered: September 2008
Location: Rainy Manchester

Senior Member

The table_name column in the various _tab_privs views is one of the worst misnamed columns in the data dicitonary. It actually includes all ojbect_types, so procedure, functions, synonyms et al as well as tables and views.

Which answers your second question as well really.

Report message to a moderator

Re: Script to list users with select on v$views [message #441071 is a reply to message #441069]

Thu, 28 January 2010 08:52

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

Senior Member
Account Moderator

1/ V_$ and V$ are same thing
2/ Same view

Regards
Michel

Report message to a moderator

Re: Script to list users with select on v$views [message #441072 is a reply to message #441070]

Thu, 28 January 2010 08:53

firefly
Messages: 53
Registered: March 2009
Location: Europe

Member

cookiemonster wrote on Thu, 28 January 2010 14:52

The table_name column in the various _tab_privs views is one of the worst misnamed columns in the data dicitonary. It actually includes all ojbect_types, so procedure, functions, synonyms et al as well as tables and views.

Which answers your second question as well really.

That's great & exectly what I was looking for! Thanks.

Report message to a moderator

Previous Topic:	sysasm privilege
Next Topic:	Auditing DML

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Dec 07 05:32:42 CST 2024