|
|
|
|
|
|
|
|
|
|
| Re: ORA-02019: connection description [message #511346 is a reply to message #511345] |
Sun, 12 June 2011 02:02  |
Database admin
Messages: 365
Registered: September 2006
Location: india
|
Senior Member |
 
|
|
Yeah..
I was told to create a db link from 'Bala' user to access 'P10' user objects of maddy database.
Find the below details
---------------------
local database - bala1
remote database -- maddy
username -bala
pwd -bala
Since Bala user does not have privilege to create db link.So i created db link
from another user 'Drum' which has create db link privilege using below command.
i created db link using below command in 'Drum' user of bala1 database.So now, only
'Drum' user can access another database objects.
CREATE DATABASE LINK maddy CONNECT TO P10 IDENTIFIED BY secret554
USING 'MADDY.WORLD';
This command got created successfully with private db link, which is not
developer requirement.Because developer wanted to access db link from 'bala' user.
Also without knowing the meaning of private and public synonym, i logged in
as bala user and gave the below query to access remote database but it returned with error.
select * from v$database@MADDY.WORLD
ORA-02019: connection description for remote database not found.
Then what i did was, i logged in as Drum user , dropped the private db link which i created ,
then created the pubic db link and thus it allowed me to access remote database
from bala user as well.
If you create public db link , any user of local db can access remote objects.
If you create private db link, only the user where you created db link can access.
Pls let me know if somebody could not understand this.
Thanks
[Updated on: Sun, 12 June 2011 02:22] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
