Re: Row-level permissions? - Mailing list pgsql-general

From Szymon Guz
Subject Re: Row-level permissions?
Date
Msg-id AANLkTinY-BtbarxfN3SRwxAsO3na4VcB2wVVJY_3wbV6@mail.gmail.com
Whole thread Raw
In response to Row-level permissions?  (gvim <gvimrc@gmail.com>)
List pgsql-general


On 30 December 2010 16:30, gvim <gvimrc@gmail.com> wrote:
Is it possible, with PostgreSQL 9.0, to restrict access to specific table rows by `id`? I want a user to be able to INSERT new rows but not UPDATE or DELETE rows with `id` < 1616.

gvim


I think the simplest way would be creating a trigger in which you would check all operations you want to restrict.


regards
Szymon

pgsql-general by date:

Previous
From: gvim
Date:
Subject: Row-level permissions?
Next
From: Richard Broersma
Date:
Subject: Re: Row-level permissions?