Create a read only user in postgresql
Posted on vr 08 juni 2012 in databases • Tagged with postgres
There apparently is no simpel way to create a user with only read / select rights on a Postgresql instance. For future reference the select statements that worked for me. The following statements produce SQL statements that must be executed to take effect :
select ‘GRANT SELECT ON ALL TABLES IN SCHEMA …
Continue reading