Scripting User Creation In SSMSE

Hi,

Strange question here. When I script a user to be created for a database deployment, I get the following script:

USE [DatabaseX]

GO

IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'newuser')

CREATE USER [newuser] WITHOUT LOGIN WITH DEFAULT_SCHEMA=[dbo]

Now, this creates the user at the 'DatabaseX' db level, but not at the 'master' db level. The user "newuser" is then not allowed access to do anything in 'DatabaseX', such as execute queries, update tables, etc.



I had to modify our script to be like this:

USE [master]

GO

CREATE LOGIN [newuser]

WITH PASSWORD=N'somepassword',

DEFAULT_DATABASE=[DatabaseX]

GO

USE [DatabaseX]

GO

CREATE USER [newuser] FOR LOGIN [newuser]

GO

USE [DatabaseX]

GO

EXEC sp_addrolemember N'db_owner', N'newuser'

GO



This allows the "newuser" to execute queries, update tables, etc. in 'DatabaseX',



Is there some option in SSMSE that I'm missing when I'm having it generate my user scripts that it's leaving the rest of the script out?



Thanks in advance for your help