OraFAQ Forum: Security » Database link password

Home » RDBMS Server » Security » Database link password (11g R2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Database link password [message #536947]

Sat, 24 December 2011 10:50

Duane
Messages: 484
Registered: December 2002

Senior Member

Is there a way to view/obtain the password once a database link has been created. Some sys dba table?

Report message to a moderator

Re: Database link password [message #536950 is a reply to message #536947]

Sat, 24 December 2011 12:41

ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

You Can not.
Password are hashed with more security On 11g.

Sriram.

Report message to a moderator

Re: Database link password [message #536954 is a reply to message #536950]

Sat, 24 December 2011 13:55

Duane
Messages: 484
Registered: December 2002

Senior Member

Thanks. That's a bummer. Too bad you can't take the hash that is used and reverse it.

Anyone know if the password is stored in some table somewhere?

Report message to a moderator

Re: Database link password [message #536955 is a reply to message #536954]

Sat, 24 December 2011 14:04

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Too bad you can't take the hash that is used and reverse it.
Then you might as well not use any password, if any/every password could be "hacked", broken or rendered useless.

>Anyone know if the password is stored in some table somewhere?
Only the hashed value is stored to maintain & enforce good security.

DBA can always over-write old password with a new password.

Report message to a moderator

Re: Database link password [message #536971 is a reply to message #536955]

Sun, 25 December 2011 03:22

Littlefoot
Messages: 21737
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

As far as I can tell, passwords should be changed periodically, so your database links will stop working as soon as it happens. Therefore, you'd need to recreate them. This scenario is not much different from what you have now - ask the schema owner to change the password and recreate the database link.

Report message to a moderator

Re: Database link password [message #536976 is a reply to message #536954]

Sun, 25 December 2011 05:44

John Watson
Messages: 8738
Registered: January 2010
Location: Global Village

Senior Member

What are you actually trying to do? For instance, you can change the password to a known value, connect and do something, and then change it back to the original (unknown) value. Or you can use connected-user links that don't need a password at all. Or can use public db links (with network detail but no password) in conjunction with private links (that have credentials but no network information).
But you can't reverse the hash, it is salted SHA1.

Report message to a moderator

Re: Database link password [message #536986 is a reply to message #536976]

Sun, 25 December 2011 09:16

Duane
Messages: 484
Registered: December 2002

Senior Member

Re-establish the database link.

I don't know how to do anything you are saying so you will have to give me some steps on the method you are mentioning.

Thanks everyone.

Report message to a moderator

Re: Database link password [message #536987 is a reply to message #536986]

Sun, 25 December 2011 10:05

John Watson
Messages: 8738
Registered: January 2010
Location: Global Village

Senior Member

Quote:

Re-establish the database link.

What do you mean? Have you dropped it, and want to create another one with the same connection details?

Report message to a moderator

Previous Topic:	FG Audit Sql_text Issue
Next Topic:	Creating table in other schema

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Aug 18 00:05:53 CDT 2022