Re: Creation of a read-only role. - Mailing list pgsql-general

From hubert depesz lubaczewski
Subject Re: Creation of a read-only role.
Date
Msg-id 9e4684ce0703170822m72bfaff4j2a128e21aef9fbff@mail.gmail.com
Whole thread Raw
In response to Creation of a read-only role.  ("Dmitry Koterov" <dmitry@koterov.ru>)
Responses Re: Creation of a read-only role.  ("Dmitry Koterov" <dmitry@koterov.ru>)
List pgsql-general
On 3/16/07, Dmitry Koterov <dmitry@koterov.ru> wrote:
> Overall, we need 3 roles:
> 1. Administrator: can do anything with a database (by default this user is
> already exists - "postgres").
> 2. Read-only: can only read. Runs on all slave nodes.

actually - you dont need the read-only role, if this is only for slave
nodes. slony takes care about the issue and doesn't allow any writes
on slaves.

depesz

pgsql-general by date:

Previous
From: Karsten Hilbert
Date:
Subject: Re: Creation of a read-only role.
Next
From: Cesar Alvarez
Date:
Subject: Store Procedures