Re: row access

From: "Scot L(dot) Harris" <webid(at)cfl(dot)rr(dot)com>
To: Bambero <robert(at)agiti(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: row access
Date: 2004-06-05 16:47:38
Message-ID: 1086454058.2282.33.camel@lathe
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)cfl(dot)rr(dot)com>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bambero 2004-06-05 16:50:56 Re: row access
Previous Message Bruno Wolff III 2004-06-05 16:45:31 Re: row access