Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Creating Private DB Link

606275Nov 20 2007 — edited Nov 20 2007
Hello:
I started to research whether it is possible to create a private database link. Indeed it is:

"To create a private database link, you must have the CREATE DATABASE LINK system privilege. To create a public database link, you must have the CREATE PUBLIC DATABASE LINK system privilege. Also, you must have the CREATE SESSION system privilege on the remote Oracle database.
Specify PUBLIC to create a public database link available to all users. If you omit this clause, the database link is private and is available only to you."

QUESTION:
--------------
As mentioned in the quoted text above, it looks like you can only make a database link private to yourself. Can one, however, make a database link private to user x, y and z? Or, perhaps a database link available only to specific users? (A fully specified database link, that is.)

Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 18 2007
Added on Nov 20 2007
13 comments
808 views