CREATE USER WITHOUT LOGIN

gknierimgknierim Posts: 31
edited June 11, 2012 11:21AM in SQL Packager Previous Versions
When I run the packager to package a database, it generates the script for the users I have as the following:
CREATE USER [MyUser] WITHOUT LOGIN WITH DEFAULT_SCHEMA=[MyUser]

How can I get packager to generate the script like the following:
CREATE LOGIN [MyUser] WITH PASSWORD = 'mYsEcReTpAsSwOrD';
GO
CREATE USER [MyUser] FOR LOGIN [MyUser] WITH DEFAULT_SCHEMA=[MyUserSchema]
GO
GRANT CONNECT TO [MyUser]
GRANT CREATE TABLE TO [MyUserSchema]

Right now I just modify the script manually after I generate it.

Thanks,
Greg

Comments

  • Thanks for your post. Unfortunately, this isn't something that's possible with the current version of the tool, but I've added a feature request in our systems for you.
    Peter Peart
    Red Gate Software Ltd
    +44 (0)870 160 0037 ext. 8569
    1 866 RED GATE ext. 8569
Sign In or Register to comment.