← 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