Is there a smarter way to grant permission to database objects besides doing a rmb on 200 folders one-by-one?
Best answer by dsj
View originalIs there a smarter way to grant permission to database objects besides doing a rmb on 200 folders one-by-one?
Best answer by dsj
View originalHi,
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!
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;
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.