CREATE LOGIN test
WITH PASSWORD = '123';
USE Northwind;
CREATE USER test FOR LOGIN test;
GO
GRANT CONNECT TO test;
GO
USE Northwind;
GRANT SELECT ON OBJECT::dbo.Customers TO test;
GO
以上创建test 登录名 并为Northwind创建用户test ,其次为test赋予CONNECT 权限、dbo.Customers 表的查询权限