Sql Source control is saving permissions for users that I don't care about
I only save certain users (app users, etc.) to source control on my linked dev database. I am not concerned about other users' object permissions. There needs to be a way to ignore them. I know you can via Schema Compare, but the ignore option needs to be in Sql Source Control.
1
vote
Brent
shared this idea
-
@Brent - would a post-deploy script work for you if we implemented something like this? ie, a script that gets appended to SQL Compare's deployment script.
-
Brent
commented
Yes, this works to ignore permissions. However, I have users in our database which our application uses. I do need their permissions. So, I need permissions to come along with 'selected' users.
-
