MANAGE SCHEDULER privilege is required to alter job class - Oracle DBA

Q.  Which privilege is required to alter a job class?
- Published on 12 Aug 15

a. MANAGE SCHEDULER
b. SYSTEM PRIVILEGE
c. ALTER ANY CLUSTER
d. SELECT

ANSWER: MANAGE SCHEDULER
 

    Discussion

  • Nirja Shah   -Posted on 24 Aug 15
    -A job defines the action to perform, the schedule for the action, and the location or locations where the action takes place.

    -A job class has some privileges granted to them.

    -MANAGE SCHEDULER - This is the most important privilege for administering the Scheduler.
    -It enables you to create, alter, and drop job classes, windows, and window groups.
    -It also enables you to set and retrieve Scheduler attributes, purge Scheduler logs, drop public credentials, set the agent password for a database.

    -SYSTEM PRIVILEGE- You can grant or revoke system privileges to users and roles. If you grant system privileges to roles, then you can use the roles to exercise system privileges.

    -ALTER ANY CLUSTER -To alter a cluster, your schema must contain the cluster or you must have the ALTER ANY CLUSTER system privilege. You can alter an existing cluster to change the following settings:

    -Physical attributes (PCTFREE, PCTUSED, INITRANS, and storage characteristics)
    -The average amount of space required to store all the rows for a cluster key value (SIZE)
    -The default degree of parallelism

    -SELECT -This is used to retrieve rows selected from one or more tables.

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