Re: Permissions and PGSQL

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Jean-Eric Cuendet <jean-eric(dot)cuendet(at)bluewin(dot)ch>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Permissions and PGSQL
Date: 2003-12-24 03:19:33
Message-ID: 20031224031933.GA16470@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Dec 16, 2003 at 13:41:32 +0500,
Jean-Eric Cuendet <jean-eric(dot)cuendet(at)bluewin(dot)ch> wrote:
> Hi,
> I use PgSql for a lot of our company's need and I lack some features.
> I would like to know if there is plans to implement:
> - User permissions based on columns? (Ex: User1 has Select on Column "CompayName"
> but User2 has update on column "CompanyName" while User3 has create new row
> on table).

As the previous responder said that is no standard column security.
However it should be possible to do something custom to do this
using rules and/or triggers.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-12-24 05:16:58 Re: Bug in new buffer freelist code
Previous Message Christopher Kings-Lynne 2003-12-24 02:37:33 Re: Quoting of psql \d output