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.

What is a left join?

0 Answers  

---

If we update a complex view, is base table will get update ?

2 Answers   Ardee Technologies, HCL,

---

Is it possible for a table to have more than one foreign key?

0 Answers  

---

List the differences between plsql - function & procedures

2 Answers   TCS, Verizon,

---

Which operator is used in query for pattern matching?

0 Answers  

---

a. Can you delete data from a View. b. If Yes, can you delete it if there are multiple tables c. If No, can you delete if there is single source table which is joining.

1 Answers   CGI,

---

What is varchar used for?

0 Answers  

---

how many ways to get the current time? : Sql dba

0 Answers  

---

Is sql a backend?

0 Answers  

---

What are the basic sql commands?

0 Answers  

---

how to check server status with 'mysqladmin'? : Sql dba

0 Answers  

---

what is 'force view'?

3 Answers   Cap Gemini, SPIC,

---