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

what is difference between delete and truncate commands? : Sql dba

575


What is memory optimized?

551


What is a loop in sql?

564


How delete all data from table in sql?

568


What is the difference among union, minus and intersect?

544






describe mysql connection using mysql binary. : Sql dba

550


what is auto increment? : Sql dba

569


Can we insert data in view?

501


Does db2 use sql?

508


How many types of relationship are there?

545


How many subqueries can be nested in a statement?

505


Who developed sql?

567


what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

525


Does execute immediate commit?

696


What are types of indexes in sql?

537