设置用户默认角色:

ALTER USER username DEFAULT ROLE connect_role;