Establishing or changing plan or package ownership

You can use the BIND and REBIND subcommands to create or change an application plan or a package.

About this task

On either subcommand, you can use the OWNER option to name the owner of the resulting plan or package. Consider the following factors when naming an owner:

Any user can name the primary ID or any secondary ID.
An ID with the BINDAGENT privilege can name the grantor of that privilege.
An ID with SYSCTRL or SYSADM authority can name any authorization ID on a BIND command, but not on a REBIND command.

If you omit the OWNER option, your primary ID becomes the owner on BIND, and the previous owner retains ownership on REBIND.

Some systems that can bind a package at a Db2 system do not support the OWNER option. When the OWNER option is not supported, the primary authorization ID is always the owner of the package because a secondary ID cannot be named as the owner.