New answers tagged privileges
Note the blog referenced in the answer given by @Gyre will not work for creating an "application" read-only user (i.e, for creating a read only role for a web application to connect to the database), and might open up a serious security vulnerability, since its easily circumventable, as explained in this postgresql list response. For reference, by the client ...
so new tables will be affected in the future? No, to affect new tables set DEFAULT PRIVILEGES: PostgreSQL CREATE TABLE creates with incorrect owner Note that default privileges are set per role.
Top 50 recent answers are included