Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

Can we call stored procedure in function?

0 Answers  

i declare 4 procedure in package specification but in package body i write only 3 procedure. is it complie??//w

4 Answers   Scope International,

difference between pl/sql table and normal pl/sql table

2 Answers  

How can we Get the Updated Rows? ie, There is 100s of Rows i updated the Rows who have salary 5000. then i want to select the Updated Rows. How can we achieve it?

4 Answers   Fidelity, KCP,

Explain what is table in a database?

0 Answers  

How do I find duplicates in the same column?

0 Answers  

What is the first action to perform a query? Suppose I have four tables and five joins and my query is getting slow day by day.

4 Answers   Hexaware,

what is a control file ? : Sql dba

0 Answers  

can we delete the trigger in a view? if yes why if not why?

5 Answers   Tech Mahindra,

What is the difference between the sql*loader and import utilities? : aql loader

0 Answers  

How would you reference column values before and after you have inserted and deleted triggers?

0 Answers  

What is orm in sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories