Re: Per-row security - Mailing list pgsql-general

From Gurjeet Singh
Subject Re: Per-row security
Date
Msg-id 65937bea0611072055i35047ceg451cfe60bd2e8fc@mail.gmail.com
Whole thread Raw
In response to Per-row security  (Alexander Staubo <alex@purefiction.net>)
List pgsql-general
On 11/4/06, Alexander Staubo <alex@purefiction.net> wrote:
I am designing an application which requires fine-grained role-based
security, where every logical object in the system has an ACL which
expresses the permissions allowed by roles.

Have you considered viel for Postgres ()? Here's what it says in it's introduction:

Introduction

Veil is a data security add-on for Postgres. It provides an API allowing you to control access to data at the row, or even column, level. Different users will be able to run the same query and see different results. Other database vendors describe this as a Virtual Private Database.


Although it is in Alpha, you should give it a try, as this will also help the project in testing the functionality in real world apps like yours.

Regards,
--
gurjeet[.singh]@EnterpriseDB.com
singh.gurjeet@{ gmail | hotmail | yahoo }.com

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: A couple more PostgreSQL C questions
Next
From: "Jim C. Nasby"
Date:
Subject: Re: [ADMIN] Is there anyway to...