SQL & PL/SQL

Hi All,

In my database (Oracle Database 11g Express Edition Release 11.2.0.2.0), I have 10 differenct users with each user having mutilple database objects ( Tables /views /procedures / functions / sequnces etc..).

My manager told me that, all the users should have all the access to all the objects which are belong to other users ( many to many).

Ex: User1 having 5 tables / 5 views / 5 functions / 5 sequences and so on. All the other users should have the access on the 'USER1's database objects.

I have succeded this by logging with User1 and explicitly grant the access on a perticular object to a perticular user.

But, How can i grant / give the access on multiple objects to multiple users at a time.

Thanks for your help in advance.

Thanks