Re: row access - Mailing list pgsql-general

From Scot L. Harris
Subject Re: row access
Date
Msg-id 1086454058.2282.33.camel@lathe
Whole thread Raw
In response to row access  (Bambero <robert@agiti.net>)
List pgsql-general
On Sat, 2004-06-05 at 12:35, Bambero wrote:
> Hi
>
> Like in the subject. I have few tables i relations with themselves.
> There are many users that may insert a rows. But i want that only owner
> can modify or delete a row.
>
> I found somwhere an information that can use here LOCK, but I don't know
> how.
>
> Please help
>
> Bambero

You can set permissions on a per table basis.  But to implement per row
permissions I think you will have to roll your own.

Probably need to add a column for who owns the row and the check that
when you perform operations on the row.

--
Scot L. Harris <webid@cfl.rr.com>


pgsql-general by date:

Previous
From: Bambero
Date:
Subject: Re: row access
Next
From: Tom Lane
Date:
Subject: Re: How to find out who is calling the function