granting updates to rows

Hi

I was wondering if there is a trick (or even a command) that allows me to grant update rights for rows with a specific criteriom to selected users or roles.

The details:
We have a table with data for and from multiple customers. These customers should be able to see (select) the data of all other customers but only write (update) data that sort of belong to them. This is, a customer would be the owner of a row when he has inserted one and then may change this row's data but not an other customer's row's data.

TIA Rene

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Aug 11 2000 - 00:00:00 CDT