Hi,
I have a requirement to create a db link to use by certain number of users. I have ended up with deciding to create a shared database link. And I used the below command to create it
CREATE SHARED DATABASE LINK <link_name>
AUTHENTICATED BY <schema_name> IDENTIFIED BY <password>
USING '<service_name>';
But my question is how this link can be accessible to other users.
I Can include one user1 in the create shared database link statement above, but how the other users can access it?
Should I do the create dblink command again with user2?
I tried to read more about the shared dblink but did not find any helpful
Please help me with this.