Get User Privileges

[CliveSwan]

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

[BillDaigle]

I agree with Blake about the triple quoted strings.  They are much cleaner and will allow you to copy and paste from a SQL editor like PLSQL or SQL Developer.

sql_statement =  """
                   SELECT *
                   FROM USER_TAB_PRIVS
                   WHERE OWNER LIKE 'GISADMN'
                 """

[BlakeTerhune]

When you have WHERE OWNER LIKE 'GISADMN' without a % wildcard, you're essentially just saying equals. For the sake of clarity, you should change it to WHERE OWNER = 'GISADMN' unless you really do want a wildcard at the beginning or end.