Re: row level grants - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: row level grants
Date
Msg-id 20040701231031.GB9893@wolff.to
Whole thread Raw
In response to row level grants  (Alexander Cohen <alex@toomuchspace.com>)
Responses Re: row level grants
List pgsql-general
On Thu, Jul 01, 2004 at 17:09:23 -0400,
  Alexander Cohen <alex@toomuchspace.com> wrote:
> Is there any way to grant user access at the row level? Or maybe some
> way to simulate it?

You can do this with views. You need something in each row that will
allow you to tell which users have access to a row and check that
against current_user in the view. If there is more than one user
per row, then you might need to join the table to another table
that maps users to groups.

pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: permissions
Next
From: "Scott Marlowe"
Date:
Subject: Re: postgresql +AMD64 +big address spaces - does it work?