Re: row level grants

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Alexander Cohen <alex(at)toomuchspace(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: row level grants
Date: 2004-07-01 23:10:31
Message-ID: 20040701231031.GB9893@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Jul 01, 2004 at 17:09:23 -0400,
Alexander Cohen <alex(at)toomuchspace(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Wolff III 2004-07-01 23:15:29 Re: permissions
Previous Message Karsten Hilbert 2004-07-01 23:07:27 Re: row level grants