Is there a smarter way to grant permission to database objects besides doing a rmb on 200 folders one-by-one?
Answer
Grant permission to database objects
+8Best answer by dsj
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!
+22Hi,
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!
DSJ - https://dsj23.me
+8Thanks for the quick reply! We will test the script asap.
+19If 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;
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.