Table update failed because of a deny on permissio

  • HI.

    We have some users whose VB program will not let them update records in a table. the security that was set on that table was to allow for select, insert,update but deny DELETE. well the program developer told me to remove the DENY and ALLOW the delete function on the table. Once that was done the users could then execute the update function. Can someone explain why the DELETE AND UPDATE would have to be allowed for just an UPDATE to take place? Or is there something coded wrong in the vb program? I'm very confused on this one.

    Juanita

  • Well, SQL takes the Update as a delete of the old values and an insert of the new ones. To avoid granting delete permissions you might use a Stored procedure to execute the updates.

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

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