-
If two databases have the users by the same name with different passwords, how should I proceed to create database link?
-
where is the problem ???
when you create a db link, the password you supply is the one of the user you will connect to (not the one you connect from) ...
-
Originally posted by pipo
when you create a db link, the password you supply is the one of the user you will connect to (not the one you connect from) ...
You can create a database link without specifying the username and password. Oracle will then try to authenticate against the target DB with the username/password of the connected user. However, the username/password must be the same on both instances for this to work.
Jeff Hunter
-
Hi friend:
I had these problems. After I implemented several replication system, i comment you the following:
* It's not necesary that the same users exist in the other database.
* You could create un private database link.
For it, first create public database link
create public database link TARGET.WORLD using 'TARGET.WORLD';
Then for the user connected to SOURCE database with which want to access to other Database:
create database link TARGET.WORLD connect to USER_TARGET identified by PASSWORD_TARGET;
Then in the database target must be exist the user USER_TARGET with the password equal to PASSWORD_TARGET.
If yuo need that other user acced with a database link, must be create a private database link using the user USER_TARGET.
if you need more help, write me to jcullas@belcorporation.com
Javier Cullas
Master Oracle
Enterprise DBA - Networked &
Distributed DBA Specialist
http://education.oracle.com/latinamerica/masters_cert/mt.names.html
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
|