Postgres Pro
Downloads
Home   >   mailing lists

Re: Controlling write access to a table - Mailing list pgsql-general

From David
Subject Re: Controlling write access to a table
Date
Msg-id 18c1e6480806180233l24f9dc10qe949044f8eaeeaa9@mail.gmail.com
Whole thread Raw
In response to Controlling write access to a table  ("Dave Coventry" <dgcoventry@gmail.com>)
List pgsql-general
Tree view 
On Wed, Jun 18, 2008 at 11:04 AM, Dave Coventry <dgcoventry@gmail.com> wrote:

[...]

> The marks (or grades) of the students are a different matter and we
> want to restrict changes to this data to a very few people.
>

How about setting up separate database users/groups (aka roles in
newer postgresql versions), and only granting update permissions to
the users/groups who should have it?

David.

pgsql-general by date:

Previous
From: "Albe Laurenz"
Date:
Subject: Re: Error when trying to drop a tablespace
Next
From: Craig Ringer
Date:
Subject: Re: Controlling write access to a table