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 ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is a materialized view? : Sql dba

571


What is dynamic query?

539


Is postgresql a nosql database?

531


What is the use of triggers?

541


Explain locks? : Transact sql

569






what is the difference between a web-garden and a web-farm? : Sql dba

556


What are the operators used in select statements?

572


How do you drop a trigger?

540


Does sql profiler affect performance?

553


Explain cursor types?

578


What is having clause in sql?

527


What is embedded sql with example?

542


What is sqlite format?

628


what does the t-sql command ident_incr does? : Transact sql

595


What is a function in oracle pl sql?

538