Shulou(Shulou.com)05/31 Report--

This article mainly shows you "what are the necessary table-building permissions in the database", which is easy to understand and well-organized, hoping to help you solve your doubts. Let the editor lead you to study and learn this article "what are the necessary table-building permissions in the database?"

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

Click (here) to collapse or open

-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

The above is all the contents of the article "what are the necessary permissions to build tables in the database?" Thank you for your reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.