Where can I find password for DB Links.
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Where can I find password for DB Links.

  1. #1
    Join Date
    Aug 2001
    Posts
    20
    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
    Certified Oracle DBA...

  2. #2
    Join Date
    Sep 2001
    Location
    Fort Smith
    Posts
    184

    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.
    sonofsita
    http://www.ordba.net

  3. #3
    Join Date
    Mar 2001
    Posts
    286
    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.

  4. #4
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    select * from sys.link$ where user_id = XXX;

  5. #5
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by Shestakov
    select * from sys.link$ where user_id = XXX;
    It is userid, not user_id!

  6. #6
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    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?


  7. #7
    Join Date
    Jan 2000
    Location
    *
    Posts
    37
    the easiest way to get passwords for database links is to query sys.links$.

    No need to export at all.

  8. #8
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    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.

  9. #9
    Join Date
    Aug 2000
    Location
    Shanghai
    Posts
    433
    Is the links$ only from oracle8+?

  10. #10
    Join Date
    Jan 2000
    Location
    *
    Posts
    37
    Sorry I added an s, it's sys.link$ not sys.links$.
    It is available in 7.3.4 as well 8.x.

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