Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unable to grant SELECT privileges to Oracle DB user

User_IIB7NSep 15 2021

Hi all,
We need to grant an oracle DB SQL user SELECT Privileges on the below tables:
• FND_RESPONSIBILITY_VL
• FND_APPLICATION_VL
• FND_USER
• FND_USER_RESP_GROUPS_DIRECT
However, we are getting the following responses from the DB (using sqlplus client):
ERROR at line 1:
ORA-00942: table or view does not exist
2021-09-15 22_56_24-Ask a Question — oracle-tech - Personal - Microsoft Edge.png Is there something I'm missing?
Appreciate any help or suggestions on this
Thanks!

This post has been answered by Solomon Yakobson on Sep 15 2021

Jump to Answer

Added on Sep 15 2021

#db, #general-database-discussions

4 comments

1,122 views