yes, we can do that... in oracle using GRANT command.. " GRANT select

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

Question Posted / sakthi santhanam.a

4 Answers
10340 Views
I also Faced
E-Mail Answers

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 are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

985

Explain the purpose of %type and %rowtype data types?

884

What is rank function in sql?

970

what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

1011

What are procedures used for?

931

Difference between truncate, delete and drop commands?

1034

Is sql sequential or random?

989

What packages(if any) has oracle provided for use by developers?

5730

How do I run sql profiler?

1018

What is pl sql script?

985

Can delete statement be rollbacked?

943

Define overloaded procedure?

1023

How to pipe multiline string to isql?

969

Why do we use subquery?

952

What are the events on which a database trigger can be based?

1113