What are the necessary permissions for creating tables in the database?
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!
