DBMS_SCHEDULER privilege

1. SCHEDULER_ADMIN

The 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 jog

For the majority of users, the CREATE JOB privilege will be sufficient.

grant create job to test

3. manage scheduler

grant manage scheduler to test

For users requiring some level of scheduler administrative privileges, the MANAGE SCHEDULER privilege allows them to create additional scheduler objects, as well as allowing them to set and retrieve scheduler attributes using the SET_SCHEDULER_ATTRIBUTE and GET_SCHEDULER_ATTRIBUTE procedures.

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/573930/viewspace-1056348/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/573930/viewspace-1056348/