Post reply

Rectrict Delete from all tables in a database.

  • July 26, 2013 at 3:37 am

    #395206

    Hi Can anyone solve my problem

    I want to restrict of all users including admin rights users that they could not delete from any tables in a particular sql server database.

    Is there any way to do this using trigger.

  • July 26, 2013 at 5:19 am

    #1636101

    you could write a trigger, but a better way would be to deny delete permissions for your users.

  • July 26, 2013 at 11:58 am

    #1636271

    steveb. (7/26/2013)

    you could write a trigger, but a better way would be to deny delete permissions for your users.

    I agree, although if "admin rights users" mean sysadmin members, there isn't a way to deny permissions.

    Greg

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

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