usmuser

Property	Value
Type	SqlUser
Login Name	usmuser
Default Schema	usmuser

Type	Action
BACKUP DATABASE	Grant
BACKUP LOG	Grant
CONNECT	Grant
CREATE DEFAULT	Grant
CREATE FUNCTION	Grant
CREATE PROCEDURE	Grant
CREATE RULE	Grant
CREATE TABLE	Grant
CREATE VIEW	Grant

SQL Script

IF NOT EXISTS (SELECT * FROM master.dbo.syslogins WHERE loginname = N'usmuser')
CREATE LOGIN [usmuser] WITH PASSWORD = 'p@ssw0rd'
GO
CREATE USER [usmuser] FOR LOGIN [usmuser] WITH DEFAULT_SCHEMA=[usmuser]
GO
GRANT BACKUP DATABASE TO [usmuser]
GRANT BACKUP LOG TO [usmuser]
GRANT CONNECT TO [usmuser]
GRANT CREATE DEFAULT TO [usmuser]
GRANT CREATE FUNCTION TO [usmuser]
GRANT CREATE PROCEDURE TO [usmuser]
GRANT CREATE RULE TO [usmuser]
GRANT CREATE TABLE TO [usmuser]
GRANT CREATE VIEW TO [usmuser]