Toad World® Forums

How to show the pwd of a dblink


#1

This is my first post so hi to all.

I’m new to toad and first I used SQLDeveloper: it was able to show me some useful info about dblink and pwd

CREATE DATABASE LINK “test_link.mydomain.com”
CONNECT TO TEST_USER
IDENTIFIED BY VALUE ‘dkjbdhqjdbhq’
USING ‘TEST_SERVICE’

Instead toad give me just the tag
CREATE DATABASE LINK “test_link.mydomain.com”
CONNECT TO TEST_USER
IDENTIFIED BY
USING ‘TEST_SERVICE’

Is there a way to have a script created as I was accustomed ?

Thanks.


#2

If you are using a version of Oracle older than 10i, you can use the sys.link$ view. There is a password column. In 10i and above, password is no longer visible (as far as I know).