Re: Row-level permissions?

From: Szymon Guz <mabewlun(at)gmail(dot)com>
To: gvim <gvimrc(at)gmail(dot)com>
Cc: pgsql <pgsql-general(at)postgresql(dot)org>
Subject: Re: Row-level permissions?
Date: 2010-12-30 15:33:16
Message-ID: AANLkTinY-BtbarxfN3SRwxAsO3na4VcB2wVVJY_3wbV6@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 30 December 2010 16:30, gvim <gvimrc(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Broersma 2010-12-30 16:11:31 Re: Row-level permissions?
Previous Message gvim 2010-12-30 15:30:08 Row-level permissions?