Tag: Read only
PostgreSQL Readonly User
Rational When you create a user in postgresql, even with only select only permission, your user has a lot more privileges. Solution Connect with root user to the desired database you will be giving permissions for: mydb=# psql -h 10.10.10.10 -U postgres mydb Now lets create the user: mydb=# create user readonly with encrypted password…