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

  • Interview Candidate
  • 1
  • 2640

Showing Answers 1 - 1 of 1 Answers

manoj bajaj

  • Apr 25th, 2006
 

Yes we can relate two tables from 2 diff 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.

1

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions