| Author |
Message |
gknierim
Joined: 16 Nov 2004
Posts: 23
|
 Posted: Fri Jun 08, 2012 6:09 pm Post subject: CREATE USER WITHOUT LOGIN |
 |
|
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 |
|
 |
peter.peartSite Admin
Joined: 02 Sep 2008
Posts: 362
Location: Top floor, RG towers with the cool kids
|
| Posted: Mon Jun 11, 2012 4:21 pm Post subject: |
|
|
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 |
|
|
|
|
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
