DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: DB link password

  1. #1
    Join Date
    Sep 2002
    Posts
    376

    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.

  2. #2
    Join Date
    Oct 2002
    Posts
    807
    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.

  3. #3
    Join Date
    Sep 2002
    Posts
    376
    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.

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    dba_db_links

    you will need to know the password suprisingly as it isnt stored

  5. #5
    Join Date
    Oct 2002
    Posts
    807
    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.

  6. #6
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    look sys.link$

  7. #7
    Join Date
    Oct 2002
    Posts
    807
    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$

  8. #8
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by pando
    look sys.link$
    The very reason I use database links without a password.
    Jeff Hunter

  9. #9
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    You can also use user_db_links to see the username and password.
    anandkl

  10. #10
    Join Date
    Mar 2004
    Location
    IA USA
    Posts
    257
    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
  •  


Click Here to Expand Forum to Full Width