Red Gate forums :: View topic - CREATE USER WITHOUT LOGIN
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Packager 6
SQL Packager 6 forum

CREATE USER WITHOUT LOGIN

Search in SQL Packager 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
gknierim



Joined: 16 Nov 2004
Posts: 24

PostPosted: Fri Jun 08, 2012 6:09 pm    Post subject: CREATE USER WITHOUT LOGIN Reply with quote

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

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


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

Code:
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
Back to top
View user's profile Send private message
peter.peart
Site Admin


Joined: 02 Sep 2008
Posts: 362
Location: Top floor, RG towers with the cool kids

PostPosted: Mon Jun 11, 2012 4:21 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group