Read Only user
I have one doubt .
I have 3 users namely user1 ,user2, user3 . I want to give user1 read only access to all objects of user2 ( including tables , triggers, views, procedures etc). How can I do this. Is there any way to achive this using profiles in Oracle 10g.
loop through user objects and grant the right access depending on type
Just to follow best practices I would...
1- Create role readonly_on_user2
2- Rely on Dave's process to grant privs to role readonly_on_user2
3- Grant role readonly_on_user2 to user1
Pablo (Paul) Berzukov
Author of Understanding Database Administration
available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Click Here to Expand Forum to Full Width