ITPub博客

1. SCHEDULER_ADMINThe SCHEDULER_ADMIN role gives a user the ability to control every aspect of the scheduler, as well as generating jobs to run as any other user. For this reason you should avoid granting it to anyone other than trusted DBAs.grant scheduler_admin to test;2. create job or create any jogFor the majority of users, the CREATE JOB privilege will be sufficient.grant create job to test3. manage schedulergrant manage scheduler to testFor users requiring some level of scheduler administr

SQL> SELECT consumer_group FROM dba_rsrc_consumer_groups;CONSUMER_GROUP------------------------------OTHER_GROUPSDEFAULT_CONSUMER_GROUPSYS_GROUPLOW_GROUPAUTO_TASK_CONSUMER_GROUP-- Create a job class.BEGINDBMS_SCHEDULER.create_job_class (job_class_name => 'test_job_class',resource_consumer_group => 'AUTO_TASK_CONSUMER_GROUP');END;/PL/SQL procedure successfully completed.SQL> SELECT job_class_name, resource_consumer_group FROM dba_scheduler_job_classes;JOB_CLASS_NAME RESOURCE_CONSUMER_