grant update on a table except to the key fields ?

From: Jean-Luc Martou <martou_at_sia.ucl.ac.be>
Date: Fri, 17 Jul 1998 12:12:16 +0200
Message-ID: <35AF2380.B023CB66@sia.ucl.ac.be>

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 - 05:12:16 CDT