Can we relate two different tables from two different users
in ORACLE,PL/SQL?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
what is self-join? : Sql dba
oracle is compiler or interpretter,can any one tell me the answer?
what is the difference between a having clause and a where clause? : Sql dba
wa procedure to return the month and the no'f developers joined in each month.
What is the difference between the conventional and direct path loads? : aql loader
HOW TO TUNE ORACLE SQL QUERIES GIVE ME STEP BY SREP
What is loop in pl sql?
What is normalization? dec 2009
how do you control the max size of a heap table? : Sql dba
In a distributed database system, can we execute two queries simultaneously?
How do I truncate a sql log file?
how many tupples can insert in 1 second in sql