REASSIGN OWNED changes the owner of a database.
REASSIGN OWNED requires that the system change owners of all the database objects owned by old_roles to new_role.
REASSIGN OWNED BY old_role [, ...] TO new_role;
Specifies the role name of the old owner.
Specifies the role name of the new owner.