SQL_SERVER snipSnap

snippet TSQL CREATE USER

--GRANT ALL SQL SERVER

USE master;
go

use [the db];
CREATE LOGIN theUser WITH PASSWORD = 'ComplexPassword01';
CREATE USER  theUser FOR LOGIN theUser;

GRANT BACKUP DATABASE, BACKUP LOG, CREATE DEFAULT, CREATE FUNCTION, CREATE PROCEDURE, CREATE RULE, CREATE TABLE, CREATE VIEW,CREATE DATABASE,CONTROL,ALTER 
TO heli

USE [the db]
GRANT BACKUP DATABASE, BACKUP LOG, CREATE DEFAULT, CREATE FUNCTION, CREATE PROCEDURE, CREATE RULE, CREATE TABLE, CREATE VIEW 
TO theUser

USE master
GO
GRANT CREATE DATABASE 
TO theUser  

DROP LOGIN theUser
DROP USER theUser