Can I prevent users from deleting tables they've created?

Question

Question by bbunn · Feb 08, 2019 at 08:23 AM · security tables drop security-model security model

Can I prevent users from deleting tables they've created?

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?

1

10 |1200 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2019-02-08T08:27:38Z

Best Answer

Answer by Kev Riley · Feb 08, 2019 at 08:27 AM

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.

1 · Share

10 |1200 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Can I prevent users from deleting tables they've created?

1 Reply

Your answer

Follow this Question

Related Questions