Post reply

Avoid field update

  • December 12, 2005 at 2:10 am

    #111025

    Hellowww!!

    Any way to avoid updates on a field?

    I'd like to do it WITHOUT USING TRIGGERS

     

    Thank you!

  • December 12, 2005 at 4:27 am

    #608959

    Could you please explain this in greater detail?

    If no updates at all are allowed, set permissions so that everybody is denied the right to update this column. Set the DENY on a role that everybody has. However, you can not deny update to the owner of the table.

    example: DENY UPDATE ON yourtable(column1) TO public

  • December 12, 2005 at 4:48 am

    #608960

    Oh! Thanks.

    This is perfect... I did'nt though about simply denying permissions.

    No need to paraphrase... as simple as it gets.

    Thanks a lot

    Sorry, my mind is cluttered... need some more chess exersize

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply