共計 14692 個字符，預計需要花費 37 分鐘才能閱讀完成。
這篇文章主要為大家展示了“數據庫中必要的建表權限有哪些”，內容簡而易懂，條理清晰，希望能夠幫助大家解決疑惑，下面讓丸趣 TV 小編帶領大家一起研究并學習一下“數據庫中必要的建表權限有哪些”這篇文章吧。
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
以上是“數據庫中必要的建表權限有哪些”這篇文章的所有內容，感謝各位的閱讀！相信大家都有了一定的了解，希望分享的內容對大家有所幫助，如果還想學習更多知識，歡迎關注丸趣 TV 行業資訊頻道！
