Database link in oracle

Question

I have a USER1 in DATABASE1 and USER2 and USER3 in DATABASE2. I am given the credentials of USER2 from which i can select only few tables on USER3. Now the requirement is, i have to create a databaselink in USER1 to query the tables in USER3. Can someone help, how to create the database link for this type of requirement?

Littlefoot · Accepted Answer · 2018-02-13 18:41:08Z

0

Here's one options: in USER2 schema create views to tables owned by USER3:

create view v_tab1 as select * from user3.tab1;

As USER1, create a database link to USER2:

create database link dbl_user2
connect to user2
identified by its_password
using 'database2_alias';

Now you can access USER2 objects, which includes both tables and views:

select * from tabx@dbl_user2;   -- selects from USER2's table
select * from v_tab1@dbl_user2; -- selects from USER3's table, via a view owned by USER2

answered Feb 13, 2018 at 18:41

Littlefoot

144k15 gold badges42 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Database link in oracle

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related