<div>
Hi!<br />
<br />
Short answer no you cannot.<br />
You can't grant such a privilege.<br />
<br />
What you can do is give a role or user, in your case role might be better so you can remove/add role to user(s) at will.<br />
<br />
What you need to do is create a role that has select rights on all views and tables in that schema.<br />
<br />
Then the user can do:<br />
select * from other_schem.table<br />
<br />
Easiest to do is:<br />
login as user1:<br />
<br />
select 'grant select on ||'table_name||' to user2' from user_tables;<br />
<br />
Now you can cut and paste this into a sql script or directly into sqlplus.<br />
<br />
This can be done for all objects and privileges that needs to be set.<br />
<br />
Hope this helps.<br />
<br />
Regards<br />
/Hans - Erik Skyttberg
</div>


Hi!

Short answer no you cannot.
You can't grant such a privilege.

What you can do is give a role or user, in your case role might be better so you can remove/add role to user(s) at will.

What you need to do is create a role that has select rights on all views and tables in that schema.

Then the user can do:
select * from other_schem.table

Easiest to do is:
login as user1:

select 'grant select on ||'table_name||' to user2' from user_tables;

Now you can cut and paste this into a sql script or directly into sqlplus.

This can be done for all objects and privileges that needs to be set.

Hope this helps.

Regards
/Hans - Erik Skyttberg

<div>
Hi!<br />
<br />
Don't forget the ';' behind user2, :)<br />
<br />
Regards<br />
/Hans - Erik Skyttberg
</div>


Hi!

Don't forget the ';' behind user2, :)

Regards
/Hans - Erik Skyttberg

<div>
Everyone was very helpful. Thanks for spelling it out for me. &nbsp;This worked great!
</div>


Everyone was very helpful. Thanks for spelling it out for me.  This worked great!

<div>
<div class="content wysiwyg-content">
Hello... &nbsp;I have a database with 2 schema's on it (one is for testing). Is there a way to grant privileges to a user with read only access to only ONE of the schema's so they can access reports runtime? If so, how? <br />
<br />
THANKS!!!!
</div>
</div>


Hello...  I have a database with 2 schema's on it (one is for testing). Is there a way to grant privileges to a user with read only access to only ONE of the schema's so they can access reports runtime? If so, how? 

THANKS!!!!

Oracle user privileges

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.