Dave, Sorry to be so late in responding to this but I may have just the solution for you. Please check out Veil at pgfoundry. This is an add-on to Postgres that I think does just what you are looking for. As the developer of this project, I would be pleased to offer you assistance. http://veil.projects.postgresql.org/ __ Marc > Date: Thu, 29 Sep 2005 10:36:23 +0700 > From: David Garamond <lists@xxxxxxxxxxxxxxxxxxxxx> > To: pgsql-general@xxxxxxxxxxxxxx > Subject: Setting up a fine-grained permission system > Message-ID: <433B6137.3070103@xxxxxxxxxxxxxxxxxxxxx> > > 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
Attachment:
signature.asc
Description: This is a digitally signed message part
