Database Links in V9 not visible

[Pavlo]

In the new PL/SQL-Developer (V9) we can't see our created database links anymore. They still exists but are not shown under Database Links. Has there been changes in the display because of the usage from multi-sessions or is this item moved (like Jobs -> DBMS_Jobs). We are using Database links for updating testsystemes with the newest developments.

 

[SunDog]

I brought this up during beta testing but that forum has been cleaned out so I can't make reference to the topic.

From what I recall, the Database Links now only shows private db links. I created a new folder in the Object Browser (courtesy of Marco) called All Database Links with a Where Clause of:

where 1 = 0 /* no results from all_objects */
union all   /* add results from all_db_links */
select owner,
       'DATABASE LINK' as object_type,
       db_link as object_name,
       'VALID' as status
  from all_db_links

For the record, I don't agree either with the default showing only private db links since in my experience it's more common to use global db links.

 

[Pavlo]

Thanks for the hint, now I know how to see them. Till now we where also used to create the database links as public. I would like to know the pre/contra of working with public database links.

 

[michaelbohler]

Your where clause did not work for me but it helped me to come up with this one which did work:

where 1 = 0 /* no results from all_objects */
union all /* add results from all_db_links */
select owner,
'DATABASE LINK' as object_type,
object_name as object_name,
'VALID' as status
from dba_objects where OBJECT_TYPE = 'DATABASE LINK'

 

[Bernhard S]

Pavlo, public database links might be a security threat. Everyone who has access to the source database, automatically has access to the target database as well and can use all the privileges there that the public database link user provides.
If you use public database links all over your databases, it might also be possible to hop from one database to the next and a DBA easily can use the overview to see all the possible security threads this way.