Users created even if I uncheck them

Forum for users of SQL Packager database archive utility

Moderator: David Atkinson

Users created even if I uncheck them

Postby andnaess » Wed Sep 10, 2008 11:09 am

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?
andnaess
 
Posts: 1
Joined: Wed Sep 10, 2008 11:00 am

Postby Michelle Taylor » Wed Sep 10, 2008 11:29 am

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.
Michelle Taylor
 
Posts: 529
Joined: Mon Oct 30, 2006 12:45 pm
Location: Red Gate Software

Postby David Atkinson » Mon Sep 29, 2008 5:42 pm

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/vi ... php?t=7743
Kind regards,

David Atkinson
Product Manager
Red Gate Software
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase


Return to SQL Packager Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests