row access

[Bambero]

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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

[Bambero]

Bruno Wolff III wrote:

On Sat, Jun 05, 2004 at 18:35:29 +0200,
Bambero <ro****@agiti.net> 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.

You don't want LOCK, you want GRANT and REVOKE.

GRANT for row access ?

If you have any ideas example please
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

[Bruno Wolff III]

On Sat, Jun 05, 2004 at 18:35:29 +0200,
Bambero <ro****@agiti.net> 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.

You don't want LOCK, you want GRANT and REVOKE.

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

[Scot L. Harris]

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 <we***@cfl.rr.com>
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings