CREATE USER WITHOUT LOGIN

gknierim

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

peter.peart

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.