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/