David Garamond <lists(at)zara(dot)6(dot)isreserved(dot)com> writes:
> 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?
In response to
pgsql-general by date
|Next:||From: Bob Parkinson||Date: 2005-09-29 12:38:51|
|Subject: DBI/DBD::Pg mem. use goes exponential|
|Previous:||From: Claus Scherschel||Date: 2005-09-29 10:51:38|
|Subject: Postgres/Win32- Upgrade from 8.0.1 to 8.0.3 fails|