row access - Mailing list pgsql-general

From Bambero
Subject row access
Date
Msg-id 40BEF95C.6040207@tlen.pl
Whole thread Raw
List pgsql-general
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.

One way is to make a triggers for every table and checking the user
field = current_user.

Please help

Bambero


pgsql-general by date:

Previous
From: jerry.levan@eku.edu (Jerry)
Date:
Subject: Need more speed for this query :)
Next
From: "Greg Sabino Mullane"
Date:
Subject: Re: Check for prepared statement