SQL 2008 R2 新增 User Password 及 開放權限

USE [TESTDB]
GO
CREATE LOGIN [username]
   WITH PASSWORD = 'password'
GO
CREATE USER [username] FOR LOGIN [username]
GO

新增USER後 記得勾取以下存取權限