Subject Re: [firebird-support] GRANT field level for select and insert
Author Helen Borrie
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

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