table access query [message #118000] |
Mon, 02 May 2005 09:29 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/53662.jpg) |
Bruce Carson
Messages: 38 Registered: February 2005 Location: Nova Scotia, Canada
|
Member |
|
|
I would like to have a dynamic query that I could use to identify every Oracle user which has access to a particular table. For example, specify a table name and the query would return the 'user' and 'method of access' (direct grant or role name).
Does anybody have a script like this?
|
|
|
Re: table access query [message #118147 is a reply to message #118000] |
Tue, 03 May 2005 05:25 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
girish.rohini
Messages: 744 Registered: April 2005 Location: Delhi (India)
|
Senior Member |
|
|
Use these views in ur query:
All_tab_privs_made view lists all object privileges that the current either has granted or for for which he owns the underlying object.
User_tab_privs_made displays only grants for which the current user is the object owner.
|
|
|