Sign Up to our social questions and Answers to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers to ask questions, answer people’s questions & connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
We have the following table and views and we need to grant SELECT to other database user to be able to SELECT from those objects.
This is the list of the table and view
FND_RESPONSIBILITY_VL FND_USER FND_USER_RESP_GROUPS_DIRECT
the normal command to grant SELECT to other user is:
GRANT SELECT ON FND_RESPONSIBILITY_VL TO CLOUD_USER;
but unfortunately while executing above script getting this error message:
ORA-00942: table or view does not exist
Hope somebody can help.
Thanks.
