At 06:24 PM 10/06/2007, you wrote:

>Looking at the definition of GRANT i see that you can grant privileges
>on field level for UPDATE (and REFERENCES) like:
>
>GRANT UPDATE (Field1, Field2) ON MyTable TO USER User1
>
>Why is field level assignment only implemented for UPDATE and not for
>SELECT and INSERT?

1. You can restrict SELECTed fields in statements
2. You can't insert fields (or delete them). You insert or delete rows.

./heLen