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
10664 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

Is natural join and inner join same?

991

What problem one might face while writing log information to a data-base table in pl/sql?

1244

Is id a reserved word in sql?

1185

how to get a list of indexes of an existing table? : Sql dba

1003

What does cursor do in sql?

1067

What is the use of count (*) in sql?

1113

What is java sql connection?

1120

What is transaction control language (tcl)?

1186

Who is the owner of mysql database?

1105

How can you know that statistics should be updated?

1125

What action do you have to perform before retrieving data from the next result set of a stored procedure ?

2608

How to use boolean type in select statement?

1135

What is the use of double ampersand (&&) in sql queries? Give an example

1187

What is exit statement?

1058

How many types of triggers are there in pl sql?

1119