Hi,

I hope you have a fair reason to grant permission to database objects of all components 

Attached script will do the job for you (tested in Apps 10).

Cheers!

Thanks for the quick reply! We will test the script asap.

If you're interested in granting SELECT privileges on any view or table, you may consider the built-in Oracle way of doing this. You'll need to run this as SYS.

GRANT SELECT ANY TABLE TO it_team;

It might also be helpful to see the instance and data dictionary views, such a V$SESSION or DBA_OBJECTS.

GRANT SELECT ANY DICTIONARY TO it_team;