AnsweredAssumed Answered

Get User Privileges

Question asked by cliveswan on May 29, 2015
Latest reply on Jun 9, 2015 by blake.terhune

I am trying to:

 

1) Determine which tables to select to get the User Privileges

 

2) Run an arcpy script to get all FeatureClass, Table priviliges

 

I get an ORA-00936 error (933 ORA-00933: SQL command not properly ended)

 

The SQL statement is:

sql_statement =

"SELECT OWNER,OBJECT_TYPE,OBJECT_NAME  \

    FROM DBA*  \

    WHERE OWNER = 'GISADMIN' and OBJECT_TYPE = 'TABLE'"

 

 

The SQL appears to be correct???

Don't understand why it is returning this error??

 

Thanks,

 

Clive

Outcomes