Creating a read-only user in PostgreSQL
First you need to create a ‘role’ (i.e. a user). You possibly also want the password to never expire: CREATE ROLE averagejoe LOGIN ENCRYPTED PASSWORD ‘***’ NOINHERIT VALID UNTIL ‘infinity’;… Read more »
First you need to create a ‘role’ (i.e. a user). You possibly also want the password to never expire: CREATE ROLE averagejoe LOGIN ENCRYPTED PASSWORD ‘***’ NOINHERIT VALID UNTIL ‘infinity’;… Read more »