sqlserver2008，创建一个用户和对应一个架构，只对这个架构下的表有访问权限

CREATE LOGIN Lg_for_test WITH PASSWORD = 'F@r-Test'

GO CREATE DATABASE ForTestGO USE ForTestGO CREATE USER u_for_test FOR LOGIN Lg_for_testGO CREATE SCHEMA NewSchemago CREATE TABLE T1(id INT,NAME VARCHAR(20))go CREATE TABLE NewSchema.T2(Nid int,DD datetime)go GRANT SELECT ON SCHEMA :: NewSchema TO u_for_test;