Skip to Main Content

Breadcrumb

May 4th

Question and Answer

Connor McDonald

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

Comments

Thank you Connor McDonald

A reader, February 26, 2017 - 5:38 pm UTC


Connor McDonald
February 27, 2017 - 12:49 am UTC

Glad we could help