Remote DB Accessing

[mkrishnanand]

Hi

I am creating a DB Link which will connect to the remote db but now my requirement is the user must be able to access only limited tables in the remote db that is the link which I created using a userid is having 10 tables in the remote db means out of that the local user must be able to access 5 tables only.

How to achieve this any idea plz.

regds

krishna

[pando]

grants ?

[mrchrispy]

what about you create a new user with the permissions you need and a dblink using that user???

[marist89]

Create an unauthenticated db link, create users on both dbs, and assign permissions.

[zainalj]

Originally posted by mrchrispy
what about you create a new user with the permissions you need and a dblink using that user???

Yea.. i think this is the best approach