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

Explain the working of primary key?

834


What are the advantages of pl sql?

832


Define join and name different types of joins?

712


What is java sql drivermanager?

744


How insert into statements in sql?

789






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

690


How to get unique records from a table?

682


Does view contain data?

788


Does sqlite need a server?

734


How do I find sql profiler?

683


Can we write dml inside a function in sql server?

675


How do you know if a relationship is 2nf?

687


what is the syntax used for partition in tsql? : Transact sql

727


What are the different types of tables in sql?

659


What are the types pl/sql code blocks?

793