Bug: filtered Users still appear in Roles (SC v10.7.0.18)

Forum for users of SQL Compare schema synchronization utility

Bug: filtered Users still appear in Roles (SC v10.7.0.18)

Postby Totu » Tue Jun 17, 2014 10:53 am

Hi Guys,

I have been working on a solution to only deploy certain users and their permissions as part of a Continuous Delivery effort.

In my experiment I follow these steps:

1. Set up comparision of SVN codebase vs empty DB.
2. Set the filters to exclude everything
3. Set filters to only include certain users (example: @name like 'dev\\%' ) and
4. Set filters to include all roles

Result: the users filtered out still appear under the roles and therefore the generated deployment script will fail due to the "missing" users.

I am also curious of what best practices or recommendations do you have for handling users when they are only supposed to be deployed to certain environments, but I think I will post that question in the RGDM forum.
A good example would be denying testers from prod access.

Bálint Bartha, Skyscanner
Posts: 11
Joined: Mon Apr 07, 2014 1:38 pm

Postby Brian Donahue » Thu Jun 19, 2014 1:45 pm

Usually this is a question of adding some options as well as excluding the users and roles objects - you can try adding the "Ignore User Properties and Role Memberships" and see if that helps. The users could be getting pulled in as part of a role.

Sorry I don't have a concrete answer - this always ends up being an environment-specific issue but when it comes to this very common user problem, it's usually related to a dependency that needs to be filled for a permission or difference in role membership.
Brian Donahue
Posts: 6590
Joined: Mon Aug 23, 2004 9:48 am

Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: Google [Bot] and 1 guest