September 13, 2007 at 4:36 am
I'm interested as to what sort of permission rights you guys assign developers to your development database server.
What does everyone do?
I thought there might have been a thread on this already but appears not to be.
September 13, 2007 at 9:28 am
We use fixed database roles in development databases. Developers are assigned to db_datareader in all databases via a group login, and db_datawriter and db_ddladmin in the particular databases they develop in. As members of those roles, developers can create objects and read and write data.
Developers aren't members of any server level roles and are never dbo of database. All databases and objects are owned by sa to facilitate cross-database ownership chaining, if needed.
Greg
Greg
September 13, 2007 at 10:51 am
Besides Greg's in my shop we do grant dbo to the developers "on development" to let them troubleshoot more advanced features as well as performing anything on the DB level. We have a "ton" of scripts that do require such permissions and a "ton" of databases are created/dropped daily.
* Noel
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply