Hi,

I wanted to move all the "rights"-management in my app to the
database.

The problem is that I for one SQL ROLE have only granted rights to
update
FIELD3 and FIELD5, but since the update statement sent to the
server looks like this:

UPDATE MYTABLE
SET FIELD1 = ? /*FIELD1*/
,FIELD2 = ? /*FIELD2*/
,FIELD3 = ? /*FIELD3*/
,FIELD4 = ? /*FIELD4*/
,FIELD5 = ? /*FIELD5*/
,FIELD6 = ? /*FIELD6*/
WHERE MYTABLE.FIELD1 = ? /*OLD.FIELD1*/

I would have hoped that there was some way that it could look like
this:

UPDATE MYTABLE
SET FIELD3 = ? /*FIELD1*/
,FIELD5 = ? /*FIELD2*/
WHERE MYTABLE.FIELD1 = ? /*OLD.FIELD1*/

I was wishing for a update changed fields only or atleast update non-
key
fields only property type of thing.

Any ideas anyone, or must I keep the rights to the TABLE-level, and
the
implement the Field stuff on the GUI?

RGDS
Steffen Nyeland