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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can we optimize a sql query?

571


Is pl sql useful?

537


What are the possible values for the boolean data field?

517


What is the non-clustered index in sql?

587


What does count (*) mean?

518






How can I tell if sql is running?

584


How do you run a query?

585


What is triggering circuit?

591


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

525


What is self-join and what is the requirement of self-join?

628


What is a pragma statement?

717


What are different sql data types?

512


how can we know the number of days between two given dates using mysql? : Sql dba

539


What are the types of functions in sql?

558


What is forward declaration in pl sql?

586