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

Q.  ___________ 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
- Published on 27 Jul 15

a. Alter
b. All
c. Execute
d. None of the above

ANSWER: Execute
 

    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


Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)