About (private) database links created by normal users
979263Dec 13 2012 — edited Jan 19 2013Hi,
I'm creating a database link that is not public (with "CREATE DATABASE LINK" instead of "CREATE PUBLIC DATABASE LINK") with a user login that has no administration privileges. This works well and the link can be used without problems.
However, I find some strange behavior:
-When I query the available links as an administrator (with "SELECT * FROM V$DBLINK"), the created link is not listed (the table returned by the query is empty). This works well if the link is created as PUBLIC instead. The database link is listed if I execute the query "SELECT * FROM V$DBLINK" with the same user that created the link. Even if the link is not public, shouldn't it be visible also for the administrator (at least, if not for using it, for the case when the administrator wants to know which database links exist)?
-I find it strange that I need to provide drop privileges to drop a public database link ("GRANT DROP PUBLIC DATABASE LINK TO ...") but this is not the case for private database links ("GRANT DROP DATABASE LINK TO ..." gives an error, and it seems that the "CREATE DATABASE LINK" privilege is enouh for both creating and dropping private links).
-Is there any way for a normal (i.e., non-admin) user to list the database links that he has created? The sentence "SELECT * FROM V$DBLINK" is executable for the administrator, but that view is not accesible to a non-admin user.
Thank you for any tips and suggestions!!