Object ownership transfer

In Db2 12, you can transfer user-defined objects to another user or role by using the new TRANSFER OWNERSHIP statement. The new owner can be an authorization ID or a role.

The privilege set for the TRANSFER OWNERSHIP statement includes the ownership of the object or the SECADM authority. The SEPARATE_SECURITY system parameter does not impact the SECADM authority.