Re: row level grants

From: Joe Conway <mail(at)joeconway(dot)com>
To: Alexander Cohen <alex(at)toomuchspace(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: row level grants
Date: 2004-07-01 21:47:32
Message-ID: 40E48674.4020407@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Alexander Cohen wrote:
> Is there any way to grant user access at the row level? Or maybe some
> way to simulate it?

There is no built-in way to do this, at least not currently.

I wrote an article that might get you going in the right direction,
available here:

http://www.onlamp.com/pub/a/onlamp/2004/06/28/postgresql_extensions.html

The functions I refer to in the article are custom C functions -- I'll
be posting the source code on my website (www.joeconway.com) sometime
after OSCON is over in a few weeks. In the meantime maybe you can use
the concepts as a starting point.

HTH,

Joe

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2004-07-01 21:48:18 Re: row level grants
Previous Message Dennis Gearon 2004-07-01 21:37:52 Re: permissions