At 09:11 AM 7/04/2004 +0000, you wrote:

>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?

Just use custom EditSQL on the dataset that you show to that role.

Helen