In one of my dev environments, I need to restrict access to all developers. Being a dev area, currently all the developers have complete access/ sysadmins. Now, we need to still retain all the access that the developer has, but just do not allow any developers to create new tables/alter existing tables. Delete is fine. (Create other objects , sps, triggers, views etc are fine). They stilll should have all other complete accesses including sql agents, execute, etc.
How can I create a new role that's almost similar to sysadmin level but minus the CREATE tables acess.