CREATE USER WITHOUT LOGIN

Packages and compresses schema and contents of SQL Server databases

Moderators: JonathanWatts, Chris Auckland, David Atkinson, david connell, Anu Deshpande, Michelle Taylor, james.billings, Marianne

CREATE USER WITHOUT LOGIN

Postby gknierim » Fri Jun 08, 2012 6:09 pm

When I run the packager to package a database, it generates the script for the users I have as the following:

Code: Select all
CREATE USER [MyUser] WITHOUT LOGIN WITH DEFAULT_SCHEMA=[MyUser]


How can I get packager to generate the script like the following:

Code: Select all
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
gknierim
 
Posts: 24
Joined: Tue Nov 16, 2004 3:16 pm

Postby peter.peart » Mon Jun 11, 2012 4:21 pm

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
peter.peart
Site Admin
 
Posts: 362
Joined: Tue Sep 02, 2008 9:58 am
Location: Top floor, RG towers with the cool kids


Return to SQL Packager 6

Who is online

Users browsing this forum: No registered users and 0 guests