Mastodon Mastodon Mastodon Systeemkabouter blog – Category databases

Create a read only user in postgresql

Posted on vr 08 juni 2012 in databases • Tagged with open source

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