Documentation privilege

Scheduler users need extra privilege if they want for example create scheduler scripts.
A new registered scheduler user can only submit public scripts.
Also extra schedule privileges are needed if a scheduler user wants for example specify an overtime period for a scheduler task.
Scheduler privileges have nothing to do with the database privileges assigned to the oracle user. So scheduler privileges cannot be maintained by granting or revoking oracle privileges.

User privileges can only be changed by scheduler users with the administrator privilege.
A scheduler user cannot change his own privileges.
The installation user always has the administrator privilege, this privilege cannot be revoked.

Scheduler user privileges are viewed and changed on the user privileges window.

Screenshot PL/SQL scheduler window W28 User privileges

Select from the scheduler window menu User -> Privileges to open the user privileges window. Select the menu option User -> Edit to change privileges from other scheduler users. Privileges can also be changed on the user monitor window.

Back to top 

Administrator privilege

A scheduler user with the administrator privilege has the following rights.

The installation user always has the administrator privilege, this privilege cannot be revoked.

Back to top 

Server log privilege

A scheduler user with the server log privilege can view the scheduler server log on the server monitor window.
On the scheduler server log the scheduler server activity can be monitored. Also errors that occur when activating scheduler tasks are written to the scheduler server log.
The installation user always has the server log privilege, this privilege cannot be revoked.

Back to top 

Developer privilege

A scheduler user with the developer privilege can create, edit and delete scheduler scripts.
The scheduler user user with the developer privilege can also grant or revoke his own scheduler scripts to and from scheduler users.
The installation user always has the developer privilege, this privilege cannot be revoked.

Back to top 

Read privilege

A scheduler user with the read privilege cannot change anything but only view. This is also the case for scheduler users with the administrator privilege.
The installation user has never read access.

Back to top 

Blocked privilege

If a scheduler user is blocked no more new scheduler tasks can be scheduled with scheduler scripts created by this user.
Existing scheduler tasks cannot be changed but are still activated.
Other activities like creating, editing, deleting, granting or revoking scheduler scripts are still possible.
The installation user is never blocked.

Disabled privilege

If a scheduler user is is disabled scheduler tasks scheduled with scheduler scripts created by this user are no longer activated.
New scheduler tasks can still be scheduled and existing can be changed and deleted.
Scheduler tasks who should be activated but for which the scheduler user is disabled get the task not activated User disabled status.
The installation user is never disabled.

Back to top 

Schedule privileges

For a scheduler user the schedule privileges can be viewed on the user privileges window (schedule panel).

Screenshot PL/SQL scheduler window W28 User privileges (schedule panel)
Flow

If set the scheduler user can create a flow.

Weekdays

If set the scheduler user can specify if a scheduler task must be scheduled on a specific day of the week.

Months

If set the scheduler user can specify if a scheduler task must be scheduled in a specific month.

Monthdays

If set the scheduler user can specify if a scheduler task must be scheduled on a specific day of the month.

Weeks

If set the scheduler user can specify if a scheduler task must be scheduled in a specific week of the year.

Repeat

If set the scheduler user can specify if a scheduler task must be repeated.

Overtime

If set the scheduler user can create for a scheduler task an overtime period.

Trace

If set the scheduler user can enable the scheduler trace for a scheduler task.

Dbms_job

If set the scheduler user can specify if a scheduler task must be restarted if the oracle server process executing the task fails.

Precreate

If set the scheduler user can specify for new scheduler tasks who are scheduled more than once that they are all created immediate.

Back to top