kamur
asked on
role : Complete access minus create tables
Hi,
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER