Sandbox DB with multiple developers and I'm being asked to prevent all table drops. I've denied DROP to all users (as SA) but if I log in as myself, I can still drop a table I created. Is this because I'm the DBOwner?
Sandbox DB with multiple developers and I'm being asked to prevent all table drops. I've denied DROP to all users (as SA) but if I log in as myself, I can still drop a table I created. Is this because I'm the DBOwner?
You can't deny DROP explicitly, you'd have to deny ALTER, which can cause other issues as it will prevent you making any changes to those tables.
One way around this is to create a database trigger on DROP that does a rollback.
17 People are following this question.