← Security
Oracle · Security

How to list all database links in Oracle

List every database link, its owner, the connect user, and the target host from DBA_DB_LINKS for a security review.

Tested on11g12c18c19c21c23ai26ai

List every database link, its owner, the connect user, and the target it points to. Passwords are never exposed by this view.

SELECT owner, db_link, username AS connect_user, host, created
FROM   dba_db_links
ORDER  BY owner, db_link;
SecurityDatabase LinksDBA_DB_LINKS