当前位置：首页 > 数据库 > MSSQL教程 > 必要的建表权限 > 正文

必要的建表权限

来源：这里教程网 时间：2026-03-02 11:12:17 作者：

点击(此处)折叠或打开

    grant create table to jirasys
         grant execute on schema::dbo to jirasys
    use [datayesdb]
     GO
     --GRANT INSERT ON SCHEMA::[dbo] TO [jirasys]
     --GO
     use [datayesdb]
     GO
     GRANT VIEW DEFINITION ON SCHEMA::[dbo] TO [jirasys]
     GO
     use [datayesdb]
     GO
     GRANT CREATE SEQUENCE ON SCHEMA::[dbo] TO [jirasys]
     GO
     use [datayesdb]
     GO
     GRANT ALTER ON SCHEMA::[dbo] TO [jirasys]
     GO
     use [datayesdb]
     GO
     --GRANT UPDATE ON SCHEMA::[dbo] TO [jirasys]
     --GO
     use [datayesdb]
     GO
     GRANT SELECT ON SCHEMA::[dbo] TO [jirasys]
     GO
     use [datayesdb]
     GO
     GRANT REFERENCES ON SCHEMA::[dbo] TO [jirasys]
     GO

点击(此处)折叠或打开

    -USE [master]
         --GO
     --CREATE LOGIN [jirasys] WITH PASSWORD=N'XXXXXXXXXXXXX', DEFAULT_DATABASE=[bigdata], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
     --GO
      
     USE [bigdata]
     DROP USER [jirasys]
     CREATE USER [jirasys] FOR LOGIN [jirasys]
     ALTER USER [jirasys] WITH DEFAULT_SCHEMA=[dbo]
     ALTER ROLE [db_ddladmin] ADD MEMBER [jirasys]
     revoke ALTER ANY ASSEMBLY from [jirasys] -- See Assembly Permissions Chart
     revoke ALTER ANY ASYMMETRIC KEY from [jirasys] -- See Asymmetric Key Permissions Chart
     revoke ALTER ANY CERTIFICATE from [jirasys] -- Certificate Permissions Chart
     revoke ALTER ANY CONTRACT from [jirasys] -- See Service Broker Permissions Chart
     revoke ALTER ANY DATABASE DDL TRIGGER from [jirasys] --
     revoke ALTER ANY DATABASE EVENT NOTIFICATION from [jirasys] -- See Event Notifications Permissions Chart
     revoke ALTER ANY DATASPACE from [jirasys] --
     revoke ALTER ANY FULLTEXT CATALOG from [jirasys] -- See Full-text Permissions Chart
     revoke ALTER ANY MESSAGE TYPE from [jirasys] -- See Service Broker Permissions Chart
     revoke ALTER ANY REMOTE SERVICE BINDING from [jirasys] -- See Service Broker Permissions Chart
     revoke ALTER ANY ROUTE from [jirasys] -- See Service Broker Permissions Chart
     revoke ALTER ANY SCHEMA from [jirasys] --See Database Permissions – Schema Objects Chart
     revoke ALTER ANY SERVICE from [jirasys] --See Service Broker Permissions Chart
     revoke ALTER ANY SYMMETRIC KEY from [jirasys] --Symmetric Key Permissions Chart
     revoke CREATE AGGREGATE from [jirasys] --
     revoke CREATE DEFAULT from [jirasys] --
     revoke CREATE FUNCTION from [jirasys] --
     revoke CREATE PROCEDURE from [jirasys] --
     revoke CREATE QUEUE from [jirasys] --
     revoke CREATE RULE from [jirasys] --
     revoke CREATE SYNONYM from [jirasys] --
     revoke CREATE TYPE from [jirasys] --
     revoke CREATE VIEW from [jirasys] --
     revoke CREATE XML SCHEMA COLLECTION from [jirasys] --
     revoke CHECKPOINT from [jirasys] --
     revoke REFERENCES from [jirasys] --
      
      
      
     USE [datayesdb]
     DROP USER [jirasys]
     CREATE USER [jirasys] FOR LOGIN [jirasys]
     ALTER USER [jirasys] WITH DEFAULT_SCHEMA=[dbo]
     ALTER ROLE [db_ddladmin] ADD MEMBER [jirasys]
     revoke ALTER ANY ASSEMBLY from [jirasys] -- See Assembly Permissions Chart
     revoke ALTER ANY ASYMMETRIC KEY from [jirasys] -- See Asymmetric Key Permissions Chart
     revoke ALTER ANY CERTIFICATE from [jirasys] -- Certificate Permissions Chart
     revoke ALTER ANY CONTRACT from [jirasys] -- See Service Broker Permissions Chart
     revoke ALTER ANY DATABASE DDL TRIGGER from [jirasys] --
     revoke ALTER ANY DATABASE EVENT NOTIFICATION from [jirasys] -- See Event Notifications Permissions Chart
     revoke ALTER ANY DATASPACE from [jirasys] --
     revoke ALTER ANY FULLTEXT CATALOG from [jirasys] -- See Full-text Permissions Chart
     revoke ALTER ANY MESSAGE TYPE from [jirasys] -- See Service Broker Permissions Chart
     revoke ALTER ANY REMOTE SERVICE BINDING from [jirasys] -- See Service Broker Permissions Chart
     revoke ALTER ANY ROUTE from [jirasys] -- See Service Broker Permissions Chart
     revoke ALTER ANY SCHEMA from [jirasys] --See Database Permissions – Schema Objects Chart
     revoke ALTER ANY SERVICE from [jirasys] --See Service Broker Permissions Chart
     revoke ALTER ANY SYMMETRIC KEY from [jirasys] --Symmetric Key Permissions Chart
     revoke CREATE AGGREGATE from [jirasys] --
     revoke CREATE DEFAULT from [jirasys] --
     revoke CREATE FUNCTION from [jirasys] --
     revoke CREATE PROCEDURE from [jirasys] --
     revoke CREATE QUEUE from [jirasys] --
     revoke CREATE RULE from [jirasys] --
     revoke CREATE SYNONYM from [jirasys] --
     revoke CREATE TYPE from [jirasys] --
     revoke CREATE VIEW from [jirasys] --
     revoke CREATE XML SCHEMA COLLECTION from [jirasys] --
     revoke CHECKPOINT from [jirasys] --
     revoke REFERENCES from [jirasys] --
      
     USE [DBA_TMP]
     DROP USER [jirasys]
     CREATE USER [jirasys] FOR LOGIN [jirasys]
     ALTER USER [jirasys] WITH DEFAULT_SCHEMA=[dbo]
     ALTER ROLE [db_ddladmin] ADD MEMBER [jirasys]
     revoke ALTER ANY ASSEMBLY from [jirasys] -- See Assembly Permissions Chart
     revoke ALTER ANY ASYMMETRIC KEY from [jirasys] -- See Asymmetric Key Permissions Chart
     revoke ALTER ANY CERTIFICATE from [jirasys] -- Certificate Permissions Chart
     revoke ALTER ANY CONTRACT from [jirasys] -- See Service Broker Permissions Chart
     revoke ALTER ANY DATABASE DDL TRIGGER from [jirasys] --
     revoke ALTER ANY DATABASE EVENT NOTIFICATION from [jirasys] -- See Event Notifications Permissions Chart
     revoke ALTER ANY DATASPACE from [jirasys] --
     revoke ALTER ANY FULLTEXT CATALOG from [jirasys] -- See Full-text Permissions Chart
     revoke ALTER ANY MESSAGE TYPE from [jirasys] -- See Service Broker Permissions Chart
     revoke ALTER ANY REMOTE SERVICE BINDING from [jirasys] -- See Service Broker Permissions Chart
     revoke ALTER ANY ROUTE from [jirasys] -- See Service Broker Permissions Chart
     revoke ALTER ANY SCHEMA from [jirasys] --See Database Permissions – Schema Objects Chart
     revoke ALTER ANY SERVICE from [jirasys] --See Service Broker Permissions Chart
     revoke ALTER ANY SYMMETRIC KEY from [jirasys] --Symmetric Key Permissions Chart
     revoke CREATE AGGREGATE from [jirasys] --
     revoke CREATE DEFAULT from [jirasys] --
     revoke CREATE FUNCTION from [jirasys] --
     revoke CREATE PROCEDURE from [jirasys] --
     revoke CREATE QUEUE from [jirasys] --
     revoke CREATE RULE from [jirasys] --
     revoke CREATE SYNONYM from [jirasys] --
     revoke CREATE TYPE from [jirasys] --
     revoke CREATE VIEW from [jirasys] --
     revoke CREATE XML SCHEMA COLLECTION from [jirasys] --
     revoke CHECKPOINT from [jirasys] --
     revoke REFERENCES from [jirasys] --
      
     USE [DBCenter]
     DROP USER [jirasys]
     CREATE USER [jirasys] FOR LOGIN [jirasys]
     ALTER USER [jirasys] WITH DEFAULT_SCHEMA=[dbo]
     ALTER ROLE [db_ddladmin] ADD MEMBER [jirasys]
     revoke ALTER ANY ASSEMBLY from [jirasys] -- See Assembly Permissions Chart
     revoke ALTER ANY ASYMMETRIC KEY from [jirasys] -- See Asymmetric Key Permissions Chart
     revoke ALTER ANY CERTIFICATE from [jirasys] -- Certificate Permissions Chart
     revoke ALTER ANY CONTRACT from [jirasys] -- See Service Broker Permissions Chart
     revoke ALTER ANY DATABASE DDL TRIGGER from [jirasys] --
     revoke ALTER ANY DATABASE EVENT NOTIFICATION from [jirasys] -- See Event Notifications Permissions Chart
     revoke ALTER ANY DATASPACE from [jirasys] --
     revoke ALTER ANY FULLTEXT CATALOG from [jirasys] -- See Full-text Permissions Chart
     revoke ALTER ANY MESSAGE TYPE from [jirasys] -- See Service Broker Permissions Chart
     revoke ALTER ANY REMOTE SERVICE BINDING from [jirasys] -- See Service Broker Permissions Chart
     revoke ALTER ANY ROUTE from [jirasys] -- See Service Broker Permissions Chart
     revoke ALTER ANY SCHEMA from [jirasys] --See Database Permissions – Schema Objects Chart
     revoke ALTER ANY SERVICE from [jirasys] --See Service Broker Permissions Chart
     revoke ALTER ANY SYMMETRIC KEY from [jirasys] --Symmetric Key Permissions Chart
     revoke CREATE AGGREGATE from [jirasys] --
     revoke CREATE DEFAULT from [jirasys] --
     revoke CREATE FUNCTION from [jirasys] --
     revoke CREATE PROCEDURE from [jirasys] --
     revoke CREATE QUEUE from [jirasys] --
     revoke CREATE RULE from [jirasys] --
     revoke CREATE SYNONYM from [jirasys] --
     revoke CREATE TYPE from [jirasys] --
     revoke CREATE VIEW from [jirasys] --
     revoke CREATE XML SCHEMA COLLECTION from [jirasys] --
     revoke CHECKPOINT from [jirasys] --
     revoke REFERENCES from [jirasys] --
      
     USE [dyedb]
     DROP USER [jirasys]
     CREATE USER [jirasys] FOR LOGIN [jirasys]
     ALTER USER [jirasys] WITH DEFAULT_SCHEMA=[dbo]
     ALTER ROLE [db_ddladmin] ADD MEMBER [jirasys]
     revoke ALTER ANY ASSEMBLY from [jirasys] -- See Assembly Permissions Chart
     revoke ALTER ANY ASYMMETRIC KEY from [jirasys] -- See Asymmetric Key Permissions Chart
     revoke ALTER ANY CERTIFICATE from [jirasys] -- Certificate Permissions Chart
     revoke ALTER ANY CONTRACT from [jirasys] -- See Service Broker Permissions Chart
     revoke ALTER ANY DATABASE DDL TRIGGER from [jirasys] --
     revoke ALTER ANY DATABASE EVENT NOTIFICATION from [jirasys] -- See Event Notifications Permissions Chart
     revoke ALTER ANY DATASPACE from [jirasys] --
     revoke ALTER ANY FULLTEXT CATALOG from [jirasys] -- See Full-text Permissions Chart
     revoke ALTER ANY MESSAGE TYPE from [jirasys] -- See Service Broker Permissions Chart
     revoke ALTER ANY REMOTE SERVICE BINDING from [jirasys] -- See Service Broker Permissions Chart
     revoke ALTER ANY ROUTE from [jirasys] -- See Service Broker Permissions Chart
     revoke ALTER ANY SCHEMA from [jirasys] --See Database Permissions – Schema Objects Chart
     revoke ALTER ANY SERVICE from [jirasys] --See Service Broker Permissions Chart
     revoke ALTER ANY SYMMETRIC KEY from [jirasys] --Symmetric Key Permissions Chart
     revoke CREATE AGGREGATE from [jirasys] --
     revoke CREATE DEFAULT from [jirasys] --
     revoke CREATE FUNCTION from [jirasys] --
     revoke CREATE PROCEDURE from [jirasys] --
     revoke CREATE QUEUE from [jirasys] --
     revoke CREATE RULE from [jirasys] --
     revoke CREATE SYNONYM from [jirasys] --
     revoke CREATE TYPE from [jirasys] --
     revoke CREATE VIEW from [jirasys] --
     revoke CREATE XML SCHEMA COLLECTION from [jirasys] --
     revoke CHECKPOINT from [jirasys] --
     revoke REFERENCES from [jirasys] --
      
      
     USE [news]
     DROP USER [jirasys]
     CREATE USER [jirasys] FOR LOGIN [jirasys]
     ALTER USER [jirasys] WITH DEFAULT_SCHEMA=[dbo]
     ALTER ROLE [db_ddladmin] ADD MEMBER [jirasys]
     revoke ALTER ANY ASSEMBLY from [jirasys] -- See Assembly Permissions Chart
     revoke ALTER ANY ASYMMETRIC KEY from [jirasys] -- See Asymmetric Key Permissions Chart
     revoke ALTER ANY CERTIFICATE from [jirasys] -- Certificate Permissions Chart
     revoke ALTER ANY CONTRACT from [jirasys] -- See Service Broker Permissions Chart
     revoke ALTER ANY DATABASE DDL TRIGGER from [jirasys] --
     revoke ALTER ANY DATABASE EVENT NOTIFICATION from [jirasys] -- See Event Notifications Permissions Chart
     revoke ALTER ANY DATASPACE from [jirasys] --
     revoke ALTER ANY FULLTEXT CATALOG from [jirasys] -- See Full-text Permissions Chart
     revoke ALTER ANY MESSAGE TYPE from [jirasys] -- See Service Broker Permissions Chart
     revoke ALTER ANY REMOTE SERVICE BINDING from [jirasys] -- See Service Broker Permissions Chart
     revoke ALTER ANY ROUTE from [jirasys] -- See Service Broker Permissions Chart
     revoke ALTER ANY SCHEMA from [jirasys] --See Database Permissions – Schema Objects Chart
     revoke ALTER ANY SERVICE from [jirasys] --See Service Broker Permissions Chart
     revoke ALTER ANY SYMMETRIC KEY from [jirasys] --Symmetric Key Permissions Chart
     revoke CREATE AGGREGATE from [jirasys] --
     revoke CREATE DEFAULT from [jirasys] --
     revoke CREATE FUNCTION from [jirasys] --
     revoke CREATE PROCEDURE from [jirasys] --
     revoke CREATE QUEUE from [jirasys] --
     revoke CREATE RULE from [jirasys] --
     revoke CREATE SYNONYM from [jirasys] --
     revoke CREATE TYPE from [jirasys] --
     revoke CREATE VIEW from [jirasys] --
     revoke CREATE XML SCHEMA COLLECTION from [jirasys] --
     revoke CHECKPOINT from [jirasys] --
     revoke REFERENCES from [jirasys] --
      
     USE [spiderDB]
     DROP USER [jirasys]
     CREATE USER [jirasys] FOR LOGIN [jirasys]
     ALTER USER [jirasys] WITH DEFAULT_SCHEMA=[dbo]
     ALTER ROLE [db_ddladmin] ADD MEMBER [jirasys]
     revoke ALTER ANY ASSEMBLY from [jirasys] -- See Assembly Permissions Chart
     revoke ALTER ANY ASYMMETRIC KEY from [jirasys] -- See Asymmetric Key Permissions Chart
     revoke ALTER ANY CERTIFICATE from [jirasys] -- Certificate Permissions Chart
     revoke ALTER ANY CONTRACT from [jirasys] -- See Service Broker Permissions Chart
     revoke ALTER ANY DATABASE DDL TRIGGER from [jirasys] --
     revoke ALTER ANY DATABASE EVENT NOTIFICATION from [jirasys] -- See Event Notifications Permissions Chart
     revoke ALTER ANY DATASPACE from [jirasys] --
     revoke ALTER ANY FULLTEXT CATALOG from [jirasys] -- See Full-text Permissions Chart
     revoke ALTER ANY MESSAGE TYPE from [jirasys] -- See Service Broker Permissions Chart
     revoke ALTER ANY REMOTE SERVICE BINDING from [jirasys] -- See Service Broker Permissions Chart
     revoke ALTER ANY ROUTE from [jirasys] -- See Service Broker Permissions Chart
     revoke ALTER ANY SCHEMA from [jirasys] --See Database Permissions – Schema Objects Chart
     revoke ALTER ANY SERVICE from [jirasys] --See Service Broker Permissions Chart
     revoke ALTER ANY SYMMETRIC KEY from [jirasys] --Symmetric Key Permissions Chart
     revoke CREATE AGGREGATE from [jirasys] --
     revoke CREATE DEFAULT from [jirasys] --
     revoke CREATE FUNCTION from [jirasys] --
     revoke CREATE PROCEDURE from [jirasys] --
     revoke CREATE QUEUE from [jirasys] --
     revoke CREATE RULE from [jirasys] --
     revoke CREATE SYNONYM from [jirasys] --
     revoke CREATE TYPE from [jirasys] --
     revoke CREATE VIEW from [jirasys] --
     revoke CREATE XML SCHEMA COLLECTION from [jirasys] --
     revoke CHECKPOINT from [jirasys] --
     revoke REFERENCES from [jirasys] --
      
     USE [topicdb]
     DROP USER [jirasys]
     CREATE USER [jirasys] FOR LOGIN [jirasys]
     ALTER USER [jirasys] WITH DEFAULT_SCHEMA=[dbo]
     ALTER ROLE [db_ddladmin] ADD MEMBER [jirasys]
     revoke ALTER ANY ASSEMBLY from [jirasys] -- See Assembly Permissions Chart
     revoke ALTER ANY ASYMMETRIC KEY from [jirasys] -- See Asymmetric Key Permissions Chart
     revoke ALTER ANY CERTIFICATE from [jirasys] -- Certificate Permissions Chart
     revoke ALTER ANY CONTRACT from [jirasys] -- See Service Broker Permissions Chart
     revoke ALTER ANY DATABASE DDL TRIGGER from [jirasys] --
     revoke ALTER ANY DATABASE EVENT NOTIFICATION from [jirasys] -- See Event Notifications Permissions Chart
     revoke ALTER ANY DATASPACE from [jirasys] --
     revoke ALTER ANY FULLTEXT CATALOG from [jirasys] -- See Full-text Permissions Chart
     revoke ALTER ANY MESSAGE TYPE from [jirasys] -- See Service Broker Permissions Chart
     revoke ALTER ANY REMOTE SERVICE BINDING from [jirasys] -- See Service Broker Permissions Chart
     revoke ALTER ANY ROUTE from [jirasys] -- See Service Broker Permissions Chart
     revoke ALTER ANY SCHEMA from [jirasys] --See Database Permissions – Schema Objects Chart
     revoke ALTER ANY SERVICE from [jirasys] --See Service Broker Permissions Chart
     revoke ALTER ANY SYMMETRIC KEY from [jirasys] --Symmetric Key Permissions Chart
     revoke CREATE AGGREGATE from [jirasys] --
     revoke CREATE DEFAULT from [jirasys] --
     revoke CREATE FUNCTION from [jirasys] --
     revoke CREATE PROCEDURE from [jirasys] --
     revoke CREATE QUEUE from [jirasys] --
     revoke CREATE RULE from [jirasys] --
     revoke CREATE SYNONYM from [jirasys] --
     revoke CREATE TYPE from [jirasys] --
     revoke CREATE VIEW from [jirasys] --
     revoke CREATE XML SCHEMA COLLECTION from [jirasys] --
     revoke CHECKPOINT from [jirasys] --
     revoke REFERENCES from [jirasys] --
      
     USE [master]
     DROP USER [jirasys]
     CREATE USER [jirasys] FOR LOGIN [jirasys]
     ALTER USER [jirasys] WITH DEFAULT_SCHEMA=[dbo]
     ALTER ROLE [db_ddladmin] ADD MEMBER [jirasys]
     revoke ALTER ANY ASSEMBLY from [jirasys] -- See Assembly Permissions Chart
     revoke ALTER ANY ASYMMETRIC KEY from [jirasys] -- See Asymmetric Key Permissions Chart
     revoke ALTER ANY CERTIFICATE from [jirasys] -- Certificate Permissions Chart
     revoke ALTER ANY CONTRACT from [jirasys] -- See Service Broker Permissions Chart
     revoke ALTER ANY DATABASE DDL TRIGGER from [jirasys] --
     revoke ALTER ANY DATABASE EVENT NOTIFICATION from [jirasys] -- See Event Notifications Permissions Chart
     revoke ALTER ANY DATASPACE from [jirasys] --
     revoke ALTER ANY FULLTEXT CATALOG from [jirasys] -- See Full-text Permissions Chart
     revoke ALTER ANY MESSAGE TYPE from [jirasys] -- See Service Broker Permissions Chart
     revoke ALTER ANY REMOTE SERVICE BINDING from [jirasys] -- See Service Broker Permissions Chart
     revoke ALTER ANY ROUTE from [jirasys] -- See Service Broker Permissions Chart
     revoke ALTER ANY SCHEMA from [jirasys] --See Database Permissions – Schema Objects Chart
     revoke ALTER ANY SERVICE from [jirasys] --See Service Broker Permissions Chart
     revoke ALTER ANY SYMMETRIC KEY from [jirasys] --Symmetric Key Permissions Chart
     revoke CREATE AGGREGATE from [jirasys] --
     revoke CREATE DEFAULT from [jirasys] --
     revoke CREATE FUNCTION from [jirasys] --
     revoke CREATE PROCEDURE from [jirasys] --
     revoke CREATE QUEUE from [jirasys] --
     revoke CREATE RULE from [jirasys] --
     revoke CREATE SYNONYM from [jirasys] --
     revoke CREATE TYPE from [jirasys] --
     revoke CREATE VIEW from [jirasys] --
     revoke CREATE XML SCHEMA COLLECTION from [jirasys] --
     revoke CHECKPOINT from [jirasys] --
     revoke REFERENCES from [jirasys] --
      
     use master
     grant exec on sys.sp_addextendedproperty to [jirasys]
      
     --use bigdata
     --grant create table on object::dbo to [jirasys]
     --use datayesdb
     --grant create table to [jirasys]
     --use dyedb
     --grant create table to [jirasys]
     --use news
     --grant create table to [jirasys]
     --use spiderdb
     --grant create table to [jirasys]
     --use topicdb


编辑推荐：

相关推荐

最新软件资讯

sql server dba大牛的秘籍
sql server dba大牛的秘籍

热文推荐

天极热推