REASSIGN OWNED changes the ownership of database objects owned by any of the old_roles to new_role.
reassign_owned ::= REASSIGN OWNED BY role_specification [ , ... ] TO role_specification role_specification ::= role_name | CURRENT_USER | SESSION_USER
REASSIGN OWNED is typically used to prepare for the removal of a role. It requires membership on both the source role(s) and target role.
Reassign all objects owned by john to yugabyte.
yugabyte=# reassign owned by john to yugabyte;