How to share DB link with another schema?

Question

I have access to two schema. Only one of them has previleges to create a DB link. I want the other schema also to use this DB link. Also I do not have intentions of creating a public DB link. Is this possible in Oracle SQL?

Answer 1

No, it is not possible. A database link is either public or private. If it is private, you cannot grant another schema access to the database link.

It is likely, however, that you can solve whatever business problem you have without needing to grant user2 access to the database link owned by user1. Commonly, for example, you would create a view in the user1 schema that queries a table over the database link and then grant user2 access to that view.