Options
Uses being created
Jparkinson
Posts: 3
Hi,
I'm new to SQL Packager - perhaps someone can help me out here.
I don't want to include the users in my database in the package I create, but even though the users aren't checked, they appear in the script and in the package when its run. The users in my dev database won't have access to the production environment where I want to deploy to.
Is there anything else I need to do to prevent the users from being part of the package?
Thanks.
Janice
I'm new to SQL Packager - perhaps someone can help me out here.
I don't want to include the users in my database in the package I create, but even though the users aren't checked, they appear in the script and in the package when its run. The users in my dev database won't have access to the production environment where I want to deploy to.
Is there anything else I need to do to prevent the users from being part of the package?
Thanks.
Janice
Comments
When using SQL Packager, one of the default options that is turned on, is 'Include Dependencies'.
I suspect it is this option that is still including the users in your package.
If you select the 'Edit Options' ->Schema Tab ->Uncheck the first option 'Include dependencies'. This action should solve your problem.
Eddie Davis
Red Gate Software Ltd
Technical Support
E-Mail: support@red-gate.com
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com
That did the trick.
Janice