Where can I find password for DB Links.

[OracDBA]

Hi,

Does any one know, if I can fibd Password for Database Links. Like all the user's passwords are in DBA_USERS.
Is there any Dictionary Table that stores the passwords for Database Links.

Thanks

[sonofsita]

CREATE PUBLIC DATABASE LINK remote_connect
CONNECT TO user_id IDENTIFIED BY password
USING 'connect string';


This tells that SQL net opens a session on the database and trys to validate the user_id with the password submitted.
The passowrd stored in the database is the password that is checked and validated.

[dba_admin]

1. Export your db links to a dmp file using EXP.
2. Use a text editor to open that dmp.

You will see passwords CLEARLY in that dmp file. If you realize this, you probably limit the use of the db links of exp from your server.

[Shestakov]

select * from sys.link$ where user_id = XXX;

[julian]

Originally posted by Shestakov
select * from sys.link$ where user_id = XXX;

It is userid, not user_id!

[julian]

Originally posted by dba_admin
1. Export your db links to a dmp file using EXP.
2. Use a text editor to open that dmp.

You will see passwords CLEARLY in that dmp file. If you realize this, you probably limit the use of the db links of exp from your server.

I think DB links are exported only after full export. Do you know of a way to export only db links?

[magskn]

the easiest way to get passwords for database links is to query sys.links$.

No need to export at all.

[Shestakov]

Originally posted by julian

Originally posted by Shestakov
select * from sys.link$ where user_id = XXX;

It is userid, not user_id!

I'm sorry it's just typo.

[ligang]

Is the links$ only from oracle8+?

[magskn]

Sorry I added an s, it's sys.link$ not sys.links$.
It is available in 7.3.4 as well 8.x.