79110242

Date: 2024-10-21 13:28:11
Score: 1.5
Natty:
Report link

To start with the original question does not in any way say that SCHEMA_DB is in a different Database, However if it is so, The db_link has to be defined in Schema MYUSER for it to work and avoid the message the user is receiving.

if however the Schema_B is in the same database then GRANT Select on the SCHEMA_B to user MYUSER should suffice.

Reasons:
  • No code block (0.5):
  • Low reputation (1):
Posted by: Darin Rodrigues