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?
Perry Whittle
SSC Guru
Points: 233902
More actions
March 17, 2013 at 1:21 pm
#1597907
after granting the roles you would need to DENY delete not REVOKE
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉