Home Forums SQL Server 2012 SQL 2012 - General how to create user that can login to create and edit but cannot delete? RE: how to create user that can login to create and edit but cannot delete?

  • March 16, 2013 at 1:12 pm

    #1597844

    Perry Whittle (3/16/2013)

    clintonG (3/14/2013)

    Circumstances require a user that can be restricted to login to a specific database to create and edit data entered into tables but cannot delete anything. I presume this type of security has been around awhile but I could not find anything searching around so I ask is it possible and if so I need to learn how.

    I may also need some help with the T-SQL because the database is being generated by script that was generated by a tool and I will have to modify that generated sql script to create the user and login.

    insert and update all tables or a handful?

    Disallow a specific User type the permission to DELETE any type of object in a specific database including disallowing deleting the database itself.

    This is a project for small businesses like pawnbrokers and second-hand resellers to record transactions they are required to report to police. I intend to disallow DELETE for what I hope is now an obvious reason. I think we call it "cover my @ss lol.