USE NewDB
GO
CREATE ROLE DemoUsers 
GO
CREATE SCHEMA DemoUsers AUTHORIZATION DemoUsers
GO
EXEC sp_addrolemember  DemoUsers, NewUser1
EXEC sp_addrolemember  DemoUsers, NewUser2
EXEC sp_addrolemember db_datareader, DemoUsers
GO