Re: Setting up a fine-grained permission system - Mailing list pgsql-general

From Douglas McNaught
Subject Re: Setting up a fine-grained permission system
Date
Msg-id m28xxg2hpw.fsf@Douglas-McNaughts-Powerbook.local
Whole thread Raw
In response to Setting up a fine-grained permission system  (David Garamond <lists@zara.6.isreserved.com>)
List pgsql-general
David Garamond <lists@zara.6.isreserved.com> writes:

> Hi,
>
> Our current project requires a fine-grained permission system (row-level
> and possibly column-level as well). We have a pretty large (tens of
> thousands) of users in the 'party' table. I'm thinking of choosing
> Unix-style security for now (adding 'ugo' and 'owner' and 'group'
> columns to each table which access need to be regulated), but am unsure
> about the column-level permission.

What about creating different views of the table, containing different
columns, with appropriate ACLs?

-Doug

pgsql-general by date:

Previous
From: Martín Marqués
Date:
Subject: Re: Problems creating view
Next
From: "Bob Parkinson"
Date:
Subject: DBI/DBD::Pg mem. use goes exponential