will try that as well . Thanks !

Thanks for all the answers. I was hoping to find such a magic table 🙂

I am already collecting recovery model for all databases in environments daily. That opton could be...

Thanks much !

I tried that but the issue is it leaves the "drop table" priviliges behind.

Also tried this but no luck

create role Developer authorization dbo;

--grant control on schema::dbo to Developer;

revoke create...