Home » RDBMS Server » Security » Database link password (11g R2)
Database link password [message #536947] Sat, 24 December 2011 10:50 Go to next message
Duane
Messages: 557
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?
Re: Database link password [message #536950 is a reply to message #536947] Sat, 24 December 2011 12:41 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
You Can not.
Password are hashed with more security On 11g.

Sriram.
Re: Database link password [message #536954 is a reply to message #536950] Sat, 24 December 2011 13:55 Go to previous messageGo to next message
Duane
Messages: 557
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?
Re: Database link password [message #536955 is a reply to message #536954] Sat, 24 December 2011 14:04 Go to previous messageGo to next message
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.
Re: Database link password [message #536971 is a reply to message #536955] Sun, 25 December 2011 03:22 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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.
Re: Database link password [message #536976 is a reply to message #536954] Sun, 25 December 2011 05:44 Go to previous messageGo to next message
John Watson
Messages: 8922
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.
Re: Database link password [message #536986 is a reply to message #536976] Sun, 25 December 2011 09:16 Go to previous messageGo to next message
Duane
Messages: 557
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.
Re: Database link password [message #536987 is a reply to message #536986] Sun, 25 December 2011 10:05 Go to previous message
John Watson
Messages: 8922
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?
Previous Topic: FG Audit Sql_text Issue
Next Topic: Creating table in other schema
Goto Forum:
  


Current Time: Thu Mar 28 04:16:45 CDT 2024