Red Gate forums :: View topic - Users created even if I uncheck them
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Packager Previous Versions
SQL Packager Previous Versions forum

Users created even if I uncheck them

Search in SQL Packager Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
andnaess



Joined: 10 Sep 2008
Posts: 1

PostPosted: Wed Sep 10, 2008 11:09 am    Post subject: Users created even if I uncheck them Reply with quote

Hi

I'm testing my SQL Packager trial on our development server. This server has login accounts for all the developers, and even though I uncheck the corresponding user objects when selecting what objects to include in the schema, the generated schema file contains CREATE LOGIN and CREATE USER statements for the users I've unchecked. Any ideas as to what I'm doing wrong?
Back to top
View user's profile Send private message
Michelle Taylor



Joined: 30 Oct 2006
Posts: 529
Location: Red Gate Software

PostPosted: Wed Sep 10, 2008 11:29 am    Post subject: Reply with quote

If you've got objects that depend on having those users in the database (e.g. the user has permissions on an object, the user owns an object or a schema) then the users will be brought along because otherwise the script wouldn't run.

You can normally shake most of them by enabling the option 'ignore users' permissions and role memberships', but obviously this will also not synchronize permissions and role memberships for other users that you might have wanted to include.

If you're sure the script will be fine afterwards you can uncheck 'Include dependencies' which will stop this happening, but that means you'll have to check manually that all of the relevant objects are in place in the target database.
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1124
Location: Twitter: @dtabase

PostPosted: Mon Sep 29, 2008 5:42 pm    Post subject: Reply with quote

Hi,

Were you able to try out Michelle's suggestions and exclude the users and logins in the end? We’ve just released a version of SQL Packager 6 that allows you to edit a script before packaging, which may help.
See http://www.red-gate.com/MessageBoard/viewtopic.php?t=7743
Kind regards,

David Atkinson
Product Manager
Red Gate Software
Back to top
View user's profile Send private message Send e-mail
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