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?
Is there a GUI application to do this?
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.
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/
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.