Re: grant update on a table except to the key fields ?

Hi,

I think it is not possible directly. You need to put this validation at the front end GUI.

Regards,

Raghu

Jean-Luc Martou wrote:

> Hi!
>
> Question :
>
> When a user is granted to update a table, he can modify all the
> fields in this table, included the fields in the primary key.
>
> How is it possible to revoke the right to modify the key fields ?
>
> Jean-Luc Martou
>
> Project Manager
> Service d'informatique administrative (SIA)
> Universite catholique de Louvain
> Place de l'Universite 1 Tel : 32-(0)10-47.81.57
> B-1348 Louvain-La-Neuve Fax : 32-(0)10-47.35.71
> Belgium
>
> Acknowledge-To: <Martou_at_sia.ucl.ac.be>
Received on Fri Jul 17 1998 - 03:16:35 CDT