Move sp_addrolemember scripts to be in User Object instead of Roles Object
In our System we have 2-3 predefined Roles that the application uses to run against.
The Issue I am running into is when scripting the roles i don't want all the sp_addrolemember being scripted into source control as the users using the role will be different in different environments. So it will always show up as a diff if the Role is already created and assigned to a user.
I would like suggest adding those sp_addroletomember scripts be configurable to be scripted in the User object they belong to instead of in the Role Object
7
votes
![](https://secure.gravatar.com/avatar/50fda136c4f64e2a3d58ae1935ce4dfc?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)