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 originalIf 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.