Grant Priviliges on column

Поиск
Список
Период
Сортировка
Искать

Grant Priviliges on column

От:
Sean Hamilton <sehamilt@chfund.org>
Дата:
Does Postgres support granting priviliges at the column level?

ex. grant update on tableA (id, description) to user

Re: Grant Priviliges on column

От:
Richard Huxton <dev@archonet.com>
Дата:
Sean Hamilton wrote:
> Does Postgres support granting priviliges at the column level?
> 
> ex. grant update on tableA (id, description) to user

No, but you can do something similar with views + rules and granting 
permissions on that.

-- 
   Richard Huxton
   Archonet Ltd

Re: Grant Priviliges on column

От:
Richard Huxton <dev@archonet.com>
Дата:
Sean Hamilton wrote:
> Does Postgres support granting priviliges at the column level?
> 
> ex. grant update on tableA (id, description) to user

... Or, perhaps with a before-update trigger.

-- 
   Richard Huxton
   Archonet Ltd

Re: Grant Priviliges on column

От:
Marc Munro <marc@bloodnok.com>
Дата:
No, but Veil allows you do it:
http://veil.projects.postgresql.org/

Be warned, implementing column or row-level privileges is not trivial.
If you are sure you need to do it and want to try Veil, I'll give you
what help I can.

__
Marc

On Fri, 2006-03-17 at 11:50 -0400, pgsql-general-owner@postgresql.org
wrote:
> Date: Fri, 17 Mar 2006 09:09:16 -0500
> From: Sean Hamilton 
> To: pgsql-general@postgresql.org
> Subject: Grant Priviliges on column
> Message-ID: <441AC30C.2080707@chfund.org>
> 
> Does Postgres support granting priviliges at the column level?
> 
> ex. grant update on tableA (id, description) to user
>
FAQ