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

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))

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

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.

how to retrieve only duplicate values in a table

9 Answers  

---

what is the boundary line in varrays?

1 Answers   HCL,

---

What is the use of partition by in sql?

0 Answers  

---

What are tuples in sql?

0 Answers  

---

difference between cursor and procedure in a package

3 Answers   PCS,

---

what are the authentication modes in sql server? How can it be changed? : Sql dba

0 Answers  

---

Do we need to rebuild index after truncate?

0 Answers  

---

When you have to use a default "rollback to" savepoint of plvlog?

0 Answers  

---

sql query to get zero records from a table having n no of records

8 Answers   CTS,

---

What are the uses of sysdate and user keywords?

0 Answers  

---

----> There is a table T with two columns C1 and C2. The data is as below: C1 C2 1 4 2 5 3 6

4 Answers   ICICI,

---

In a Distributed Database System Can we execute two queries simultaneously ? Justify ?

3 Answers  

---