Skip site navigation (1) Skip section navigation (2)

Re: Setting up a fine-grained permission system

From: Douglas McNaught <doug(at)mcnaught(dot)org>
To: David Garamond <lists(at)zara(dot)6(dot)isreserved(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Setting up a fine-grained permission system
Date: 2005-09-29 12:15:07
Message-ID: m28xxg2hpw.fsf@Douglas-McNaughts-Powerbook.local (view raw or flat)
Thread:
Lists: pgsql-general
David Garamond <lists(at)zara(dot)6(dot)isreserved(dot)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

In response to

pgsql-general by date

Next:From: Bob ParkinsonDate: 2005-09-29 12:38:51
Subject: DBI/DBD::Pg mem. use goes exponential
Previous:From: Claus ScherschelDate: 2005-09-29 10:51:38
Subject: Postgres/Win32- Upgrade from 8.0.1 to 8.0.3 fails

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group