| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Bruno Wolff III <bruno(at)wolff(dot)to> |
| Cc: | Alexander Cohen <alex(at)toomuchspace(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: row level grants |
| Date: | 2004-07-02 03:59:34 |
| Message-ID: | 9182.1088740774@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Bruno Wolff III <bruno(at)wolff(dot)to> writes:
> 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.
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-07-02 04:08:06 | Re: max_fsm_pages |
| Previous Message | mike g | 2004-07-02 03:55:53 | Re: cygpopt-0.dll problem, ipc-daemon2 |