Resource for Ignoring Database Permissions

Is there a good resource for dealing with Database Source Control permissions.

I am trying to run "Redgate DLM Automation" task in VSTS, it keeps failing saying a role has not been created. I believe my original check had no filters setup or someone checked in with no filters. I have added comparision options and filters so as no permissions should be checked. But it is still failing because those permissions are already checked. 

Since I don't know the best way to handle this in a lab environment I am seeking a resource and how to setup redgate source control ignoring permission's and how to stop someone from accidentally checking in permissions. 

My permissions change per environment and I have the scripts to create these permissions, but I am struggling to see the point in Redgate deployment where to add these scripts and how to prevent someone from introducing bad security.

Best Answer


Sign In or Register to comment.