Re: read only connection

On Thu, 06 Nov 2003 23:59:29 +0100
Gaetano Mendola <mendola(at)bigfoot(dot)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(at)jefftrout(dot)com>
http://www.jefftrout.com/
http://www.stuarthamm.net/