-
DB link password
Hi,
How can i see the username and password used to create the db link.
Using SQL navigator we can get the db link creation script. But apart from that, is ther any way to retrieve the same.
-
If you have access to dba_users on the target database, simply change the password of the schema, get in , do your stuff, and alter the password back to the ORIGINAL with an "alter user blah identified by VALUES " clause.
-
Originally posted by Axr2
If you have access to dba_users on the target database, simply change the password of the schema, get in , do your stuff, and alter the password back to the ORIGINAL with an "alter user blah identified by VALUES " clause.
I have no idea what u r saying.
My requirement is just to know the username and password.
By the way altering the user with identifed by doesn't work becuase password history profile has been set.
-
dba_db_links
you will need to know the password suprisingly as it isnt stored
-
Originally posted by bang_dba
By the way altering the user with identifed by doesn't work becuase password history profile has been set.
Huh? The hashed password for every schema is visible in dba_users. I was merely giving you the age old way of getting into a schema when you don't know its password. If your ultimate objective is to actually know what the password is (and not just login as that schema/user) --- IGNORE my previous post.
You are not going to find clear text password stored any where. You are gonna have to work with hash values.
-
-
Originally posted by Axr2
You are not going to find clear text password stored any where. You are gonna have to work with hash values.
I stand corrected. Like pando says look at sys.link$
-
Originally posted by pando
look sys.link$
The very reason I use database links without a password.
Jeff Hunter
-
You can also use user_db_links to see the username and password.
anandkl
-
Originally posted by pando
look sys.link$
yes, use this to know the password for a database link.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|