Re: read only connection

Jeff wrote:
> On Thu, 06 Nov 2003 23:59:29 +0100
> Gaetano Mendola <mendola@bigfoot.com> wrote:
>
>
>>Already asked, I try again:
>>
>>7.4 give the feature to have transaction in
>>read only mode, is it possible give permission
>>to an user to perform db connection in read only
>>mode ?
>>
>
>
> create user readonlyuser;
> revoke insert on [table] from readonlyuser
> revoke update on [table] from readonlyuser
> revoke delete on [table] from readonlyuser

I know but is not system/tables wide.
Each time that a table is created I shall remember
to revoke the permission, what I was looking for
was an option to insert into pg_hba.conf


Regards
Gaetano Mendola