Exclude Grant/Permissions

sheldonhull

I couldn't find a way to do this with the SQL Compare filters, as it's a project level option. I want to track schema changes, but exclude monitoring the permissions changes, as this is done with a dynamic script and makes a lot of noise in DLM. Any ideas on if this is possible?

BryanEargle

The IgnoreUsersPermissionsAndRoleMemberships associated with SQL Compare can be set in SQL Source Control as a comparison option. Even though I'm not seeing it explicitly called out in the docs, this excludes schema permissions (in addition to user permissions and role membership.