<div>
yes I'm aware of that but I am looking for a cleaner way of doing this if possible, I don't want to be having to run this script to grant access multiple times a day to ensure user B has access to all of user A's schema
</div>


yes I'm aware of that but I am looking for a cleaner way of doing this if possible, I don't want to be having to run this script to grant access multiple times a day to ensure user B has access to all of user A's schema

<div>
Check this out -<br />
<br />
<a href="http://www.oracle-base.com/articles/misc/SchemaOwnersAndApplicationUsers.php" rel="ugc">http://www.oracle-base.com/articles/misc/SchemaOwnersAndApplicationUsers.php</a><br />

</div>


Check this out -

http://www.oracle-base.com/articles/misc/SchemaOwnersAndApplicationUsers.php [http://www.oracle-base.com/articles/misc/SchemaOwnersAndApplicationUsers.php]


<div>
<div class="content wysiwyg-content">
I have a user (user A) in oracle who has a lot of objects under their schema, I wish to give access to these tables to another user (user B).<br />
<br />
I want to avoid the following if possible<br />
1. creating public synomyns for all the objects under user A.<br />
2. having to grant User B access to User A's on a object level (for example 1000000 tables and 1 million grants.<br />
<br />
Is there a way to do this ? I have seen something to do with proxy users but I am not sure I have understood it correctly.
</div>
</div>


I have a user (user A) in oracle who has a lot of objects under their schema, I wish to give access to these tables to another user (user B).

I want to avoid the following if possible
1. creating public synomyns for all the objects under user A.
2. having to grant User B access to User A's on a object level (for example 1000000 tables and 1 million grants.

Is there a way to do this ? I have seen something to do with proxy users but I am not sure I have understood it correctly.

Oracle Grant total schema access to user

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.