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>