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.