| 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: | Whole Thread | Raw Message | 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>
| 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 |