Hacker News Reader

Comment by echion | Hacker News Reader

> To be able to select from a table you need

> * CONNECT

> * USAGE

> * SELECT

  Only roles that have the LOGIN attribute can be used as the initial role name for a database connection

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.

Good point. Connecting to the Cluster is indeed actually a 4th layer.

There you do need user with LOGIN, valid password & SSL.