数据库中必要的建表权限有哪些

这篇文章主要为大家展示了“数据库中必要的建表权限有哪些”，内容简而易懂，条理清晰，希望能够帮助大家解决疑惑，下面让小编带领大家一起研究并学习一下“数据库中必要的建表权限有哪些”这篇文章吧。

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=NXXXXXXXXXXXXX, 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

以上是“数据库中必要的建表权限有哪些”这篇文章的所有内容，感谢各位的阅读！相信大家都有了一定的了解，希望分享的内容对大家有所帮助，如果还想学习更多知识，欢迎关注行业资讯频道！