Can we relate two different tables from two different users
in ORACLE,PL/SQL?
- 4 Answers
- 8990 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 many rows can sqlite handle?
how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba
How do I remove sql developer from windows 10?
What does the hierarchical profiler does?
How do I run a sql script?
What is a native sql query?
How to disable a trigger name update_salary?
How to look at the current sql*plus system settings?
What are the two different parts of the pl/sql packages?
Can we have two clustered index on a table?
What is dynamic query?
How can we solve sql error: ora-00904: invalid identifier?
What is the difference between rollback and rollback to statements?
what are the type of locks ? : Sql dba
What are the different types of dbmss?
