Red Gate forums :: View topic - Database deployment with IgnoreUsers still drops users...
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
Deployment Manager
Deployment Manager forum

Database deployment with IgnoreUsers still drops users...

Search in Deployment Manager forum
Post new topic   Reply to topic
Jump to:  
Author Message
matthoneycutt



Joined: 07 Apr 2014
Posts: 7

PostPosted: Thu Apr 10, 2014 12:47 pm    Post subject: Database deployment with IgnoreUsers still drops users... Reply with quote

My deployment has RedGateDatabaseOptionsIgnoreUsers=true, but about every other release is still dropping users from the target database. How can I tell Deployment Manager to completely ignore users when applying a release?
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1144
Location: My desk.

PostPosted: Mon Apr 14, 2014 5:42 pm    Post subject: Reply with quote

The ignore users doesn't actually ignore users in the way you'd probably think it does...
It actually affects how explicit permissions on objects are deployed:

Quote:
When role-based security is used, object permissions are assigned to roles, not users. If this option is set to true, Deployment Manager only deploys object permissions for roles, and members of roles that are themselves roles. Users' permissions and role memberships are ignored.


If you want to exclude users altogether, you'd really need to look at using a Filter file in your package.
If you're using our SQL Source Control you can create a filter and check it into your repository as described here
You can also create a filter in SQL Compare if you use that - making sure you save the file as "Filter.scpf", and then include it in your package.
Back to top
View user's profile Send private message
Totu



Joined: 07 Apr 2014
Posts: 10

PostPosted: Mon Apr 21, 2014 11:07 am    Post subject: Reply with quote

Hi James,

I have a similar problem.
I am not using any filters and using default settings for the RGDM.

The problem in short is that role members are ignored when I want to deploy the database. I have looked up the SQL Compare default settings and it doesn't say it is set to true by default.

I have set it explicitly to false and it fixed my problem. The question remains: why is it not using the default settings for SQL Compare?

Cheers,
Balint

EDIT: I looked up the RGDM documentation and indeed it is set to true by default. Apologies for that. Additional question: is there a way to set the defaults other than per-project? We are using an alternate method to persist security objects and for that we need the option to be set to false at all of our projects.
_________________
Bálint Bartha, Skyscanner
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1144
Location: My desk.

PostPosted: Mon Apr 21, 2014 11:23 am    Post subject: Reply with quote

I think that DM had the option set to True because in many cases DM is used to deploy to various different production DB's where you may want to leave users alone, rather than deploying changes to them.
In the case of SQL Compare, we tend to minimise the amount of default "ignore" options that are set so the majority of differences are available for deployment.
It basically comes down to a difference in the intended usage.
Back to top
View user's profile Send private message
Totu



Joined: 07 Apr 2014
Posts: 10

PostPosted: Mon Apr 21, 2014 1:31 pm    Post subject: Reply with quote

Hi James,

Thanks for the info.
Now that I think, it makes sense to have it that way. I think it is our alternative way that made the difference in the deployment.


Thanks,
Balint
_________________
Bálint Bartha, Skyscanner
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group