Home » SQL & PL/SQL » SQL & PL/SQL » Identifying access privileges
Identifying access privileges [message #189189] Wed, 23 August 2006 09:53 Go to next message
techvader01
Messages: 17
Registered: August 2006
Location: Los Angeles
Junior Member
What queries can I run to find out who has access to a particular object like a table?

Can I also find out what objects a particular user has been granted access to? Razz
Re: Identifying access privileges [message #189192 is a reply to message #189189] Wed, 23 August 2006 10:21 Go to previous messageGo to next message
JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland
Senior Member
select * from dict where table_name like '%PRIV%'

will provide you with a list of tables that will be useful.
Re: Identifying access privileges [message #189194 is a reply to message #189192] Wed, 23 August 2006 10:25 Go to previous messageGo to next message
techvader01
Messages: 17
Registered: August 2006
Location: Los Angeles
Junior Member
Thank you very much!! This will be very helpful.
Re: Identifying access privileges [message #189196 is a reply to message #189194] Wed, 23 August 2006 10:27 Go to previous message
JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland
Senior Member
If find these 2 queries really useful:

SELECT * FROM dict
WHEREtable_name LIKE upper('%&tab_name');

and

SELECT * FROM dict_columns
WHERE column_name LIKE upper('%&col_name%');

ut then I have a rotten memory and can never remember the name of the table that I need Smile
Previous Topic: Trigger Prob.
Next Topic: eliminate leading zeros on text field
Goto Forum:
  


Current Time: Sun Dec 04 14:24:36 CST 2016

Total time taken to generate the page: 0.10542 seconds