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 the difference between jpql and sql?

0 Answers  

---

Define the select into statement.

0 Answers  

---

Why we use stored procedure instead of query?

0 Answers  

---

I have following column in the table. col1 1 a b c 2 3 d and I want to display it as num chars 1 a 2 b 3 c 4 d numbers in one column and letters in another column.

1 Answers   IBM, Saama Tech,

---

What is the difference between an inner join and an outer join?

0 Answers  

---

What is scalar function in sql?

0 Answers  

---

What is rename command in sql?

0 Answers  

---

can i use dbms_output.put_line in a function u are telling as return statement

7 Answers  

---

Who is the owner of mysql database?

0 Answers  

---

How many joins in sql?

0 Answers  

---

Can we create view in stored procedure?

0 Answers  

---

How do you update a value in sql?

0 Answers  

---