Execute privilege can only be granted for programs, chains, and job classes - Oracle DBA

Discussion

• Nirja Shah   -Posted on 26 Aug 15
  -Following are the privileges which are important when we are using a scheduler.
  
  -EXECUTE - This privilege can only be granted for programs, chains, and job classes.
  -It enables you to create a job that runs with the program, chain, or job class. -It also enables you to view object attributes.
  
  -ALTER - This privilege enables you to alter or drop the object it is granted on.
  -Altering includes such operations as enabling, disabling, defining or dropping program arguments, setting or resetting job argument values and running a job. For programs, jobs, and chains, this privilege enables you to view object attributes.
  -This privilege can only be granted on jobs, chains, programs and schedules.
  -For other types of Scheduler objects, you can grant the MANAGE SCHEDULER system privilege.
  
  - ALL - This privilege authorizes operations allowed by all other object privileges possible for a given object.
  -It can be granted on jobs, programs, chains, schedules and job classes.

➨ Post your comment / Share knowledge