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

Which join condition can be specified using on clause?

694


What is the difference between sql and mysql?

753


how can you see all indexes defined for a table? : Sql dba

703


Can we change the table name in sql?

697


What is the plv (pl/vision) package offers?

792






Explain what is table in a database?

779


What are the qualities of 2nf?

747


What is the current version of sql?

724


What are pl/sql cursors?

726


Is inner join same as self join?

779


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

740


Can you have more than one trigger on a table?

704


How we can update the view?

811


What is lexical units in pl sql?

749


Define concurrency control. : Transact sql

785