| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bob Parkinson | 2005-09-29 12:38:51 | DBI/DBD::Pg mem. use goes exponential |
| Previous Message | Claus Scherschel | 2005-09-29 10:51:38 | Postgres/Win32- Upgrade from 8.0.1 to 8.0.3 fails |