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 the difference between cluster and non-cluster index?
what happens if null values are involved in expressions? : Sql dba
What is a trigger ?
11 Answers Accenture, BirlaSoft,
what are the disadvantages of mysql? : Sql dba
How is debugging done?
How to perform a loop through all tables in pl/sql?
What is a mutating table
What are the different datatypes available in PL/SQL?
Who developed sql?
Types of optimization?
How do you get all records from 2 tables. Which join do you use?
What are the benefits of triggers?