Re: How to grant a user read-only access to a database? - Mailing list pgsql-general

On Wednesday 03 March 2010 08:19:46 am Tom Lane wrote:
> Kevin Kempter <kevink@consistentstate.com> writes:
> > I believe all you have to do is this to create a read only user:
> > create user ro_user with password 'passwd';
> > alter user ro_user set default_transaction_read_only = true;
>
> You do realize the user can just unset that again?
>
>             regards, tom lane


I did not. Thanks for the heads up.