Thanks for the question, kishore.
Asked: February 22, 2017 - 3:02 pm UTC
Last updated: February 27, 2017 - 12:49 am UTC
Version: 11.2.0.3.0
Viewed 1000+ times
You Asked
Hi,
For instance,
i have a dblink db123 in database1 and t2 table in database2 ,
i want to access only one table t2@database2 from database1 by using dblink db123 ,
except t2@database2 that dblink db123 should not accessible/valid for rest of tables .
and Connor said...
A database link is just like a client connection to the remote database.
So if my database link is:
connect to user_a
identified by my_password
using 'remote_tns_details'
then I will get the privileges of "user_a" on the remote database. So on the remote database you would provide only the necessary grants to user_a for the objects you want to see.
Rating
(1 rating)
Is this answer out of date? If it is, please let us know via a Comment