On Thu, 06 Nov 2003 23:59:29 +0100 Gaetano Mendola <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> http://www.jefftrout.com/ http://www.stuarthamm.net/ ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
