GRANT SELECT for Oracle Ouput

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

Output

Accepted answers

sbaker

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.

All comments

MarqueeCrew

Try this:

GRANT SELECT ON TABLE MyTable TO MyUser

...

<span class="kwd">GRANT</span> <span class="kwd">SELECT</span><span class="pun">,</span> <span class="kwd">UPDATE</span><span class="pun">,</span> <span class="kwd">DELETE</span><span class="pun">,</span> <span class="kwd">INSERT ON TABLE MyTable TO MyUser</span>

Cheers,

Mark

sbaker

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703