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 17, 2013 at 1:54 pm

    #1597912

    GilaMonster (3/17/2013)

    Or, instead of using the roles, you could GRANT SELECT, INSERT, UPDATE on the database instead.

    Make sure that the login is not sysadmin, the user is not db_owner and you're not logged in as that user. All of those will cause the permissions to fail.

    Yup, already been down this route although I initially recommended insert and update at schema level only.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉