示例5.sql

来自「SQL基础教程上的一些源码」· SQL 代码 · 共 19 行

USE sampleDB
GO
CREATE ROLE ManagerGroup
GO

CREATE SCHEMA sampleDbSchema AUTHORIZATION ManagerGroup
GO

CREATE LOGIN sampleDbManger1 WITH PASSWORD = '12345',
DEFAULT_DATABASE = sampleDB
GO

CREATE USER sampleDbManger1 FOR LOGIN sampleDbManger1
WITH DEFAULT_SCHEMA = sampleDbSchema
GO

sp_addrolemember 'ManagerGroup', 'sampleDbManger1'
GRANT CREATE TABLE TO sampleDbManger1
GO