GRANT SELECT for Oracle Ouput

[sbaker]

I created an Oracle table as an Output under my Oracle user.  I am able to see the table and its data & properties in Oracle.  I am not able to query it.  Oracle told me that Alteryx must grant my user permission.  I attempted the following as Pre Create SQL and Post Create SQL in the configuration.  I received the typical error - ORA-00942: table or view does not exist.  Is is true that Alteryx needs to grant permission; if so, how is it passed?

GRANT SELECT, INSERT on MyUser to MyTable

[MarqueeCrew]

Try this:

GRANT SELECT ON TABLE MyTable TO MyUser

...

GRANT SELECT, UPDATE, DELETE, INSERT ON TABLE MyTable TO MyUser

Cheers,

Mark

[sbaker · Accepted solution]

Thank you MarqueeCrew.   It turns out the error had nothing to do with Alteryx.  I specified Alteryx to create a table name using lower cases.  Oracle table names should be upper case.  I changed the table name to be all upper case and queries work fine.

[DavidAngevine]

i appreciate this post.   I had a similar problem in Teradata and the table was not available for me to read.  After reading this post, I changed the select statement to UC.  Then, I was able to read from Teradata SQL application, and no more changes were needed in Alteryx.

Since I defined the table create as UC in Teradata, it could only be read in as an UpperCase name as USERDB.TABLENAME.  

Thanks for sharing and this may be true for other SQL environments.