这篇文章主要为大家展示了"数据库中必要的建表权限有哪些",内容简而易懂,条理清晰,希望能够帮助大家解决疑惑,下面让小编带领大家一起研究并学习一下"数据库中必要的建表权限有哪些"这篇文章吧。
授予jirasys创建表的权限
将schema:dbo上的执行权限授予jirasys
使用[datayesdb]
去
-将SCHEMA:上的插入内容授予[jirasys]
-走吧
使用[datayesdb]
去
将SCHEMA:上的视图定义授予[jirasys]
去
使用[datayesdb]
去
将SCHEMA:上的创建序列授予[jirasys]
去
使用[datayesdb]
去
授予[jirasys]更改计划:[dbo]
去
使用[datayesdb]
去
-将架构:3360[dbo]的更新授予[jirasys]
-走吧
使用[datayesdb]
去
将SCHEMA:上的选择授予[jirasys]
去
使用[datayesdb]
去
将SCHEMA:上的参考资料授予[jirasys]
去
点击(此处)折叠或打开
-使用[主]
-走吧
-使用密码创建登录[jirasys]=N ' xxxxxxxxxxxxx ',DEFAULT_DATABASE=[bigdata],CHECK _ expire=OFF,CHECK_POLICY=OFF
-走吧
使用[大数据]
删除用户
为登录创建用户
用DEFAULT_SCHEMA=[dbo]更改用户[jirasys]
ALTER ROLE[db _ ddladmin]ADD MEMBER[jirasys]
撤销[jirasys]中的更改任何程序集-请参见程序集权限表
撤销从[jirasys]更改任何非对称密钥-请参见非对称密钥权限表
撤销[jirasys] -证书中的"更改任何证书"
e 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
以上是“数据库中必要的建表权限有哪些”这篇文章的所有内容,感谢各位的阅读!相信大家都有了一定的了解,希望分享的内容对大家有所帮助,如果还想学习更多知识,欢迎关注行业资讯频道!
内容来源网络,如有侵权,联系删除,本文地址:https://www.230890.com/zhan/82739.html