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