QUESTION POSED ON: 21 April 2006
I have the following query. I created two users, U1 and U2, then created role R. I created tables in user U1 and gave grants to select, insert, update and delete to role R. I assigned role R to U2. Now if I log in through user U2 then I am able to see all objects of user U1. I can perform a similar operation by creating a public synonym in U1, i.e., I create a public synonym in user U1 and see all objects of user U2.
What is the difference between these two approaches? Is there any question of efficiency? If yes, then which one is better?
|
