Difficult in database link

[holdingbe]

Hi,
I get very difficult requirement from my friend.

I explain clearly below :

I have two databases.

Source databases: Flower
|__________sche ma: sample.
|______table :emp,dept,bonus ,qa
Destination databases: Margin.
|__________sche ma:Testing.
|______ table :emp,dept,bonus ,qa


Now, I login in flower databases in sample schema. I need select data from
Emp table from margin database in testing schema. At the same time I don’t want to access the other tables from margin database in testing schema.

What I try:
I create database link between flower databases and margin databases.i able to select data from all tables from margin database in testing
Schema.

I need to access emp table only and I don’t want other tables.

Please help me.

Thanks,
Michael

[amitpatel66]

Hi,
I get very difficult requirement from my friend.

I explain clearly below :

I have two databases.

Source databases: Flower
|__________sche ma: sample.
|______table :emp,dept,bonus ,qa
Destination databases: Margin.
|__________sche ma:Testing.
|______ table :emp,dept,bonus ,qa


Now, I login in flower databases in sample schema. I need select data from
Emp table from margin database in testing schema. At the same time I don’t want to access the other tables from margin database in testing schema.

What I try:
I create database link between flower databases and margin databases.i able to select data from all tables from margin database in testing
Schema.

I need to access emp table only and I don’t want other tables.

Please help me.

Thanks,
Michael

Well, once you create a database link, make use of that link to access only emp table. Dont access other tables if you dont want to do that.

[debasisdas]

When you create a DBLINK ,you need to provide the User name and Password.

So for the user using the DBLINK, the previliges are like the owner of the objects of the entire linked schema.