这篇文章主要为大家展示了“数据库中必要的建表权限有哪些”,内容简而易懂,条理清晰,希望能够帮助大家解决疑惑,下面让小编带领大家一起研究并学习一下“数据库中必要的建表权限有哪些”这篇文章吧。
-
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
以上是“数据库中必要的建表权限有哪些”这篇文章的所有内容,感谢各位的阅读!相信大家都有了一定的了解,希望分享的内容对大家有所帮助,如果还想学习更多知识,欢迎关注亿速云行业资讯频道!
原创文章,作者:Maggie-Hunter,如若转载,请注明出处:https://blog.ytso.com/205356.html