DBMS_SCHEDULER privilege

最新推荐文章于 2021-04-09 16:48:50 发布

转载最新推荐文章于 2021-04-09 16:48:50 发布 · 143 阅读

本文详细阐述了SQL调度器管理角色（SCHEDULER_ADMIN）的使用与限制，包括如何授予该角色、权限分配（如创建作业、管理调度器等），以及避免非信任DBA滥用该权限的重要性。

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/