Read Only user

Hello All

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.

Regards
Raju

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