Using ArcSDE on an Oracle DB, how can I tell which users have permissions to a Feature Class

Question

I created a new Feature Class, and I assigned some users SELECT privileges to that Feature Class. I want to look at the list of users that I have assigned privileges to, how do I do that?

Updated

Is there a GUI application to do this?

Answer 1

via sql from shell:

select grantee, privilege from dba_tab_privs where table_name = 'FEATURECLASS_NAME' and owner = 'SCHEMA_NAME';

this will give you the list of users that have privs to that feature class's business table. if you granted privs via arccatalog, then the privs will be for the entire feature class.

Answer 2

It's been a couple of years since i've used oracle and ArcSDE, but I think I used some Oracle SQL(sqlplus from shell) to figure out what was granted. I don't have the SQL, but it would be something along the lines of: http://oraclepitstop.wordpress.com/2008/05/29/sql-script-to-list-oject-privileges-granted-to-a-particular-user/

select grantor || ‘ granted ‘ || privilege || ‘ on ‘ || table_name || ‘ owned by ‘|| owner || ‘ to ‘|| grantee 
from dba_tab_privs 
where grantee like upper(‘&GRANTEE_NAME’) 
order by privilege;

The GDB Toolset might also have this functionality, but it was just as easy(and faster) for me to set up a batch file to query the info. But you do need to sort through the various sde/gdb/adds&deletes tables that will get reported back.