Skip to content
← SQL Source Control

How can we improve SQL Source Control?

SQL Source Control

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Allow an option to exclude members of database roles from SSC.

We like to control access to objects using database roles. However, the members of the roles are different in different environments (dev, test and live). I want to include the roles (and their permissions) in SSC, but don't want SSC to worry about the members of the roles - this can be handled manually.

19 votes
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Pete Cousins shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Balint Bartha commented  ·   ·  Report

    Hi Guys,

    We are using Filter files to avoid comparison of certain objects - it is MS Replication objects and procedures in our case.
    If you add the filter file to the root of your db scripts folder, SSC and SC should apply it and ignore those objects.

    I hope it helps.

    Cheers,
    Totu

  • Anonymous commented  ·   ·  Report

    If users are added to a role, it will also cause SQL Compare to want to create a new schema matching the user name, if the users doesn't exist in the target database.