Re: read only connection

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


you could do it with a group as well.

>
>
> Regards
> Gaetano Mendola
>
>
> ---------------------------(end of
> broadcast)--------------------------- TIP 5: Have you checked our
> extensive FAQ?
>
>                http://www.postgresql.org/docs/faqs/FAQ.html


--
Jeff Trout <jeff@jefftrout.com>
http://www.jefftrout.com/
http://www.stuarthamm.net/