Re: row level grants - Mailing list pgsql-general

From Tom Lane
Subject Re: row level grants
Date
Msg-id 9182.1088740774@sss.pgh.pa.us
Whole thread Raw
In response to Re: row level grants  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-general
Bruno Wolff III <bruno@wolff.to> writes:
>   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.

There are working examples of this in the standard distribution.
Take a look at the pg_stats view and the information_schema views.

            regards, tom lane

pgsql-general by date:

Previous
From: mike g
Date:
Subject: Re: cygpopt-0.dll problem, ipc-daemon2
Next
From: Tom Lane
Date:
Subject: Re: max_fsm_pages