Red Gate forums :: View topic - Dynamic Database Deployment Security Objects
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

Dynamic Database Deployment Security Objects

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



Joined: 29 Aug 2013
Posts: 2

PostPosted: Thu Aug 29, 2013 4:20 pm    Post subject: Dynamic Database Deployment Security Objects Reply with quote

When doing a dynamic database deployment any user role assignments or users that were not on the database the package was created from get removed.

Is there any way to stop this happening as we often have different database users and role assignments across our development, QA, UAT and production environments?
Back to top
View user's profile Send private message
david.conlin



Joined: 04 May 2012
Posts: 49

PostPosted: Mon Sep 02, 2013 10:45 am    Post subject: Reply with quote

Hi there -

If you are using SQL Source Control or SQL compare you can take their filter file and make Deployment Manager obey it using the technique below.

www.red-gate.com/messageboard/viewtopic.php?t=17776
[/url]
_________________
David Conlin
Software Developer
Deployment Manager
Back to top
View user's profile Send private message
amaher



Joined: 29 Aug 2013
Posts: 2

PostPosted: Mon Sep 02, 2013 1:05 pm    Post subject: Reply with quote

Thank you - That has done the trick.
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