You can log in and then change your role (if you permissions) with SET ROLE NEW_USER; We managed to kludge our way to defaulting to read only, then using set r

You can log in and then change your role (if you permissions) with SET ROLE NEW_USER; We managed to kludge our way to defaulting to read only, then using set role to do writes if you need to.