CREATE LOGIN Lg_for_test WITH PASSWORD = 'F@r-Test'
GO
CREATE DATABASE ForTest
GO
USE ForTest
GO
CREATE USER u_for_test FOR LOGIN Lg_for_test
GO
CREATE SCHEMA NewSchema
go
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;