Creating Private DB Link
606275Nov 20 2007 — edited Nov 20 2007Hello:
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.