Re: BEGIN WORK READ ONLY; - Mailing list pgsql-general

From A. Kretschmer
Subject Re: BEGIN WORK READ ONLY;
Date
Msg-id 20061014195612.GA1515@a-kretschmer.de
Whole thread Raw
In response to Re: BEGIN WORK READ ONLY;  (Michael Fuhr <mike@fuhr.org>)
List pgsql-general
am  Sat, dem 14.10.2006, um 13:35:21 -0600 mailte Michael Fuhr folgendes:
> On Sat, Oct 14, 2006 at 11:35:12AM -0700, Joshua D. Drake wrote:
> > What is the use case for a READ ONLY transaction?
>
> I use read-only transactions as a safety net for interactive sessions
> when I want to avoid modifying anything accidentally.  Here's an
> example:
>
> CREATE ROLE foo LOGIN PASSWORD 'password';
> CREATE ROLE foo_ro LOGIN PASSWORD 'password';
> ALTER ROLE foo_ro SET default_transaction_read_only TO on;
> GRANT foo TO foo_ro;

Great.


Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47215,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: BEGIN WORK READ ONLY;
Next
From: Ron Johnson
Date:
Subject: Re: BEGIN WORK READ ONLY;