Tag Info

New answers tagged

1

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 ...


2

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