Re: granting updates to rows

I can think of two ways of doing it.

1. grant update on the whole table and then have a before update trigger that checks the user and rollsback the update if the user does not own the data.
2. grant select on the main table to all. Then create a view the returns only the data that belongs to an individual. Then grant update on the view. to all. the view would be something like create view update_table as select * from table where owner_column = user;

HTH Conan