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.