ALTER JOB

The ALTER JOB statement transfers ownership of a between or .

Required privileges

To alter job ownership, the user must be one of the following:

• The current job owner.
• A member of the role that is the current owner.
• An admin.

Unless the user is an admin, they can only transfer ownership of a job to themselves or to a role of which they are a member.

To add a user to a role, refer to the statement.

Synopsis

Parameters

Parameter	Description
a_expr	The job ID to modify.
role_spec	The role or user.

Example

To transfer job ownership from the user who created the job to a role they’re a member of:

ALTER JOB job_id OWNER TO role_name;

See also