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

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 ?

It depends on how you are accessing your db. You can trap this through your business rule objects before the sql hits the db. Or you can only update through stored procs and control the access through them.

hth
Doug

Opinions expressed herein are my own and may not represent those of my employer. Received on Fri Jul 17 1998 - 09:57:14 CDT