question

Luis Castillo <luiscastillor@gmail.com> writes:

I would like to know how can I control in my database the rows that a
user has inserted. I mean many users can insert information in a table
but when trying to update the information I want that a user can change
only those rows inserted by him. Is this possible with Postgresql?

Sure, if you add a column that records which user inserted the row, and
then make a BEFORE UPDATE trigger that throws an error if it doesn't
match.

regards, tom lane

am Tue, dem 07.10.2008, um 21:20:53 -0400 mailte Tom Lane folgendes:

Luis Castillo <luiscastillor@gmail.com> writes:

I would like to know how can I control in my database the rows that a
user has inserted. I mean many users can insert information in a table
but when trying to update the information I want that a user can change
only those rows inserted by him. Is this possible with Postgresql?

Sure, if you add a column that records which user inserted the row, and
then make a BEFORE UPDATE trigger that throws an error if it doesn't
match.

Additional, create a text-column with default current_user for the
inserts. Example:

kretschmer@pegasus:~$ psql -U kretschmer test
...

test=> create table usertab (id serial, username text default current_user);
NOTICE: CREATE TABLE will create implicit sequence "usertab_id_seq" for serial column "usertab.id"
CREATE TABLE
test=*> insert into usertab values(default, default);
INSERT 0 1
test=*> select * from usertab;
id | username
----+------------
1 | kretschmer
(1 row)

Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net