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

How do you rename a table in sql?

1114

Why do we create views in sql?

1154

how to do backup entire database? : Transact sql

1146

Is natural join same as inner join?

943

How does postgresql compare to oracle/db2/ms sql server/informix?

1035

Is sqlexception checked or unchecked?

969

how to convert character strings to dates? : Sql dba

1063

Why do we go for stored procedures?

1057

How do you define a foreign key?

1005

how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba

1002

How do you get column names only for a table (sql server)?

1166

Can you selectively load only those records that you need? : aql loader

1048

What is the process of copying data from table a to table b?

1093

Why is a primary key important?

1044

What is memory optimized?

1088