Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

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?

share|improve this question

2 Answers 2

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.

share|improve this answer
    
I was hoping to have a GUI app for this, but still good info. –  mlsteeves Aug 9 '10 at 17:59

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.

share|improve this answer
    
I don't see an option in GDB to see Privileges. :) Do you know of another GUI app that might have this functionality? –  mlsteeves Aug 9 '10 at 17:59

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.