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