1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

Can we relate two different tables from two different users
in ORACLE,PL/SQL?

Question Posted / swapna

Answers were Sorted based on User's Feedback



Can we relate two different tables from two different users in ORACLE,PL/SQL?..

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

Can we relate two different tables from two different users in ORACLE,PL/SQL?..

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

Can we relate two different tables from two different users in ORACLE,PL/SQL?..

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

Can we relate two different tables from two different users in ORACLE,PL/SQL?..

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

Post New Answer

More SQL PLSQL Interview Questions

What is a merge query?

1 Answers  

What is cursor in pl sql with examples?

0 Answers  

What is the current version of sql?

0 Answers  

How can you tell the difference between an index and a view?

0 Answers  

What is meant by truncate in sql?

0 Answers  




What is the main difference between a UNION statement and a UNION ALL statement? 1. A UNION statement eliminates duplicate rows; a UNION ALL statement includes duplicate rows. 2. A UNION statement can be used to combine any number of queries; a UNION ALL statement can be used to combine a maximum of two queries. 3. A UNION statement can only combine queries that have parallel fields in the SELECT list; a UNION ALL statement can combine queries with differing SELECT list structures. 4. A UNION statement cannot be used with aggregate functions; a UNION ALL statement can be used with aggregate functions. 5. There is no difference between the two statements; they are interchangeable.

2 Answers   Saman Bank, Sonata,

Given two tables Student(SID, Name, Course) and Level(SID, level) write the SQL statement to get the name and SID of the student who are taking course = 3 and at freshman level.

9 Answers   Oracle,

What can sql server reporting services do?

0 Answers  

What does (*) mean in sql?

0 Answers  

how to rename an existing column in a table? : Sql dba

0 Answers  

What are all ddl commands?

0 Answers  

Differentiate between sga and pga.

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories