clintonG (3/16/2013)

---

You could grant the user insert and update permission on the schema the objects reside in.

I was going to try it this way:

EXEC sp_addrolemember db_datareader, $(DatabaseUserName)

EXEC sp_addrolemember db_datawriter, $(DatabaseUserName)

REVOKE DELETE

ON $(DatabaseName)

FROM {$(DatabaseUserName)}

* Is the syntax correct?

* Is there anything problematic with this approach?