Setting permissions for developers

  • Hi,

    I am a newbie to db administration.  I recently read an article that said that developers shouldn't assigned to the db_owner role.  Right now, we are creating a pseudo user for each app we develop and then assign it the public and db_owner roles.  If I am understanding it correctly, this shouldn't be done. If the DBA (that is me) is to create objects and the developers are to access them for development, can I just create a role giving all permissions to the role and then directly assign the role to the windows user id of the developers. 

     

    Which is the best way to go about this?  (should have been my first question...sorry)  Somebody help me out.

     

    Vis.

  • Easiest way is to create an NT windows group, SQL role and assign the SQL role the permissions and have the "User" of that role be the NT group.

    IF the developers are creating items in DEV why not allow them to be DBO?  Once the code progresses through your testing environments would they not lose their permissions?



    Good Hunting!

    AJ Ahrens


    webmaster@kritter.net

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply