Re: How to grant a user read-only access to a database?

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