GRANT OWNERSHIP ON ROLE command: Restrict transfer of role ownership to itself (Pending)¶

When this behavior change bundle is enabled, the transfer of role ownership will be restricted as follows:

Before the change:

Users can grant ownership of a role to the role itself. For example, the following GRANT statement is allowed:

GRANT OWNERSHIP ON ROLE my_role TO ROLE my_role;

Copy

After the change:

Users can no longer grant ownership of a role to the role itself. For example, the following GRANT statement returns an error:

GRANT OWNERSHIP ON ROLE my_role TO ROLE my_role;

Copy

003645 (42501): SQL execution error: Transferring OWNERSHIP of a role to itself is not allowed.

Ref: 1781