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

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