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:47 pm

    #1597911

    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.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass