How to create a user with readonly privileges for all databases in Postgresql?
You need to do 2 things: firstly, allow access to existing objects; and secondly, set the default access for new objects created from now on. Note that granting access to “TABLES” includes views, but does not include sequences (such as the auto-increment function for “SERIAL” columns), so you’ll probably want to grant access to those … Read more