mssql sql로 database, user 생성 방법

USE MASTER
GO

CREATE DATABASE [DB명]
GO

CREATE LOGIN [LOGIN명] WITH PASSWORD='비밀번호'
GO

ALTER LOGIN [LOGIN명] Enable
GO

USE [DB명]
GO

CREATE USER [USER명] FOR LOGIN [LOGIN명] WITH DEFAULT_SCHEMA = dbo
GO

EXEC sp_addrolemember db_owner, [USER명]
GO

--GRANT ALL TO [USER명]
--GO

기억은 못하겠고 적어 두자.