Re: ANNOYING MESSAGE.....?

In article <5807@hpwala.wal.hp.com> kistler@hp-and.an.hp.com "Jim Kistler" writes: > Does anyone know.........? > > I have built a table with several columns that use restricted select and > update privileges, ie: "public" may see the entries when using the data > entry form, but may not select or update the form's fields for these > columns. "public" needs to routinely insert/update any of the other entries > to the table, however, and select/update privileges are granted to > "public" for all the other columns of the table. > > HOWEVER, when "public" accesss the table for routine data entry, without > touching the restricted fields/columns, an annoying message appear each > time a data entry is completed: > > "permission not granted to allow reading of 'field_name'". Have you tried to create a view and use the form on the view ? create view view_name as select only,the,columns,allowed from the_table -- Mike Aubury ...---...