Subject Re: [IBO] privileges and Requestlive
Author Nando Dessena
Rick,

R> When logged in as roll = WAREHOUSE I can open the table now and
R> browse, but when I try to edit ANY field I get a GDS error
R> 335544352 "no permission..." error on one of the non-editable fields.

R> When I look at the SQL monitor the Update statement includes all the
R> fields in the table including the ones for which there is no Update
R> privilege.

been there. Setting PreparedEdits to False should have the effect of
raising exceptions only when you actually edit a non-editable field
(also have a look at PreparedInserts). Not that I consider it a very
effective user interface. If I was you I'd leave column-level security
and use views instead.

Ciao
--
Nando Dessena