| table access query [message #118000] |
Mon, 02 May 2005 09:29  |
 |
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  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
