SQL 2008 R2.
Is there a way to "deny drop objects" (tables/procs/views..) on a database where a user has read/write + Alter permissons without using triggers?
Basically I would like the users to go crazy without deleting objects, they can create/modify/truncate whatever they want, just not delete anything.
You can't. As soon as you GRANT CONTROL on a schema, or worse, make people the database owner, you've granted them that control. There isn't a way to parse it.
answered Dec 11, 2013 at 11:02 AM
Grant Fritchey ♦♦