Can we relate two different tables from two different users in ORACLE,PL/SQL?

Can we relate two different tables from two different users
in ORACLE,PL/SQL?

Question Posted / swapna

4 Answers
9045 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Can we relate two different tables from two different users in ORACLE,PL/SQL?..

Answer / sakthi santhanam.a

yes, we can do that... in oracle using GRANT command..
" GRANT select on table_name to nextuser(2nd user)"
this is the query...
wish you all the success
sakthi.A

Is This Answer Correct ?

4 Yes

0 No

Can we relate two different tables from two different users in ORACLE,PL/SQL?..

Answer / shilpa.oracle

Yes, we can relate tables of different schemas provided we
should have privileges on that table

create table test_emp
(empno number(5),deptno number(5),constraint dept_ref
foreign key (deptno) references schema.dept(deptno))

Is This Answer Correct ?

2 Yes

1 No

Can we relate two different tables from two different users in ORACLE,PL/SQL?..

Answer / sakthi santhanam.a

yes, we can do that... in oracle using GRANT command..
" GRANT select on table_name to nextuser(2nd user)"
this is the query...
wish you all the success
sakthi.A

Is This Answer Correct ?

2 Yes

2 No

Can we relate two different tables from two different users in ORACLE,PL/SQL?..

Answer / swapna

Yes we can relate two tables from 2 different users

E.g. if user A has table Ta and User B has Table Tb and
Table Tb is child table and needs foreign
key on A.Ta then
we need to grant "references" object privillege to User B
on table Ta.

Is This Answer Correct ?

0 Yes

1 No

Post New Answer