This discussion is archived
6 Replies Latest reply: Jan 25, 2013 1:51 PM by Srini Chavali-Oracle RSS

public database link username

gamalraj Newbie
Currently Being Moderated
Gentlemen,

I would like to recreate the public database links with new username and password. Prior to that, I want to know which user the current public database link in connecting to.

The dba_db_links table shows only the user name for private database links. Where can I find the username for public database link.

e.g.,

SQL> create public database link abc.domain.com connect to targetuser idenitified by targetpassword using 'abc.doman.com';

Where I find the information about targetuser; it is not shown in dba_db_links table for public database links.

Thanks

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points