Granting Multiple Object Privileges:
It is possible to manage privileges for multiple objects from the Multiple Object privileges screen. Grant or revoke privileges on multiple objects at once by doing the following:
1. From the Database | Administer menu, select Multiple Object Privileges. To grant privileges, click the Grant tab.
2. Select the Green arrow to select grant for particular user. To revoke privileges, click the Revoke tab.