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.
Anyone has experiences to share on a similar system/requirement? Do you do Unix-style or ACL? Is there a possibility in the medium/far future that Postgres will have such a fine-grained permission system. Regards, Dave ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
