Home » RDBMS Server » Security » table access query
table access query [message #118000] Mon, 02 May 2005 09:29 Go to next message
Bruce Carson
Messages: 38
Registered: February 2005
Location: Nova Scotia, Canada
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
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.

Previous Topic: REVOKE doesnot work
Next Topic: directory and create directory rights
Goto Forum:

Current Time: Mon Sep 25 17:34:30 CDT 2023