Home » RDBMS Server » Security » Script to list users with select on v$views
Script to list users with select on v$views [message #441065] Thu, 28 January 2010 08:25 Go to next message
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
Re: Script to list users with select on v$views [message #441068 is a reply to message #441065] Thu, 28 January 2010 08:38 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Query DBA_TAB_PRIVS

Regards
Michel
Re: Script to list users with select on v$views [message #441069 is a reply to message #441065] Thu, 28 January 2010 08:46 Go to previous messageGo to next message
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
Re: Script to list users with select on v$views [message #441070 is a reply to message #441065] Thu, 28 January 2010 08:52 Go to previous messageGo to next message
cookiemonster
Messages: 13917
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.
Re: Script to list users with select on v$views [message #441071 is a reply to message #441069] Thu, 28 January 2010 08:52 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ V_$ and V$ are same thing
2/ Same view

Regards
Michel
Re: Script to list users with select on v$views [message #441072 is a reply to message #441070] Thu, 28 January 2010 08:53 Go to previous message
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.
Previous Topic: sysasm privilege
Next Topic: Auditing DML
Goto Forum:
  


Current Time: Thu Mar 28 15:23:58 CDT 2024