views:

71

answers:

1

how to create the schema,

AND USING SCHEMA HOW TO create tables under the schemas

+1  A: 
CREATE SCHEMA RTFM AUTHORIZATION dbo
GO
CREATE TABLE RTFM.foo (bar int NOT NULL)
GO
GRANT SELECT ON ::RTFM TO MyRole
GO

CREATE SCHEMA and GRANT

gbn