SQL Server Security Granularity

I have had some questions recently about how to grant developers certain permissions without giving them sysadmin rights. Hopefully this summary will help you determine how to grant the least possible privileges. The summary is based on SQL Server 2005 but will also apply to SQL Server 2008. · I would hesitate to grant any more permissions in development than they get in production. This means avoid not only sysadmin but also db_owner where possible. o This avoids problems where they spend a long…(read more)