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.

Is sql better than excel?

0 Answers  

---

How many joins can you have in sql?

0 Answers  

---

If i insert record in table A and these record should update in table B by using Trigger.How to achieve this.

4 Answers   Saama Tech, TCS,

---

What is flag in sql?

0 Answers  

---

What jobs use sql?

0 Answers  

---

What is parameter substitution in sql?

0 Answers  

---

what are the different type of normalization? : Sql dba

0 Answers  

---

Delete duplicate records in the emp table.

6 Answers   Oracle,

---

how to see the create table statement of an existing table? : Sql dba

0 Answers  

---

what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba

0 Answers  

---

Is there a way to automate sql execution from the command-line, batch job or shell script?

0 Answers  

---

What is primary key and foreign key with example?

0 Answers  

---