Post reply

Does SQL Server 2005 have: user defined server level security groups

  • May 23, 2006 at 8:13 am

    #94245

    All

    Our environment has lots of 30 development databases.   The development staff has 45 people who have access to the environment.   Access varries by database, but usually the developers have access to read and write data plus some create procedure permissions. 

    What I am looking for is this:  

    • A group or role that is defined at the server level ( developer )
    • the group would cross mulitple databases
    • from each database I would grant permissions to the group
    • and all developers would be added as members to developer group

    Is this possible or am I stuck doing 1350 seperate manual grants across my environment?

     

    Thanks in advance

    Eric Peterson

  • May 23, 2006 at 4:05 pm

    #639625

    Eric,

    I am not sure you can define a custom server-level role, I have not heard of one. There are several fixed server roles and you can Grant/Deny/Revoke certain statement permissions like Create Database stetement to logins.  Roles are in the databases. You sure can use those. Again, you can script a set of permissions and apply them to logins or roles just changing a database name or a set when creating roles if they are more or less standard from database to database. Sort of permission template script.So you have to deal only 1 script which you would run with USE statement using databases one at a time when creating roles. And the second script will be applied to each login granting server-level permissions.

     

    Regards,Yelena Varsha

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

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