Can we relate two different tables from two different users
in ORACLE,PL/SQL?
- 4 Answers
- 9727 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
How to test for null values?
Is sql a case sensitive language?
What is data control language?
What jobs use sql?
What is bulk compiling in pl/sql.?
Why we use joins in sql?
Can we create table in function?
What is union?
What is pls_integer in pl sql?
What is the difference between having and a where in sql?
what is a database lock ? : Sql dba
What is coalesce sql?
what are the authentication modes in sql server? : Sql dba
What is nvarchar in sql?
How do you determine the current isolation level? : Transact sql
