Solved

Grant permission to database objects

  • 21 October 2019
  • 3 replies
  • 541 views

Userlevel 4
Badge +8

Is there a smarter way to grant permission to database objects besides doing a rmb on 200 folders one-by-one?

icon

Best answer by dsj 22 October 2019, 12:23

View original

3 replies

Userlevel 7
Badge +20

Hi,

 

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

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

 

Cheers!

Userlevel 4
Badge +8

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

Userlevel 7
Badge +18

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;

 

Reply