使用此：



创建多个用户：

Use this:

To create multiple user:

CREATE LOGIN <login name=""> WITH PASSWORD = '<password>' ; GO  

To restrict the user for particular database:

USE master
go
DENY VIEW ANY DATABASE TO [user]
go

USE master;
GO
ALTER AUTHORIZATION ON DATABASE::yourDB TO User;
GO