创建架构

Created: November-22, 2018

CREATE SCHEMA dvr AUTHORIZATION Owner
    CREATE TABLE sat_Sales (source int, cost int, partid int)
    GRANT SELECT ON SCHEMA::dvr TO  User1
    DENY SELECT ON SCHEMA::dvr to User 2
GO