Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

public database link username

gamalrajJan 25 2013 — edited Jan 25 2013
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 22 2013
Added on Jan 25 2013
#database-security, #database-security-general
6 comments
1,276 views