-
SQL SERVER2008 存储过程、表、视图、函数的权限
- EXEC sp_addrolemember N'db_owner', N'db'
- EXEC sp_droprolemember N'db_owner', N'db'
- ALTER AUTHORIZATION ON SCHEMA::[db_datareader] TO dbs
- ALTER AUTHORIZATION ON SCHEMA::[db_datareader] TO db
- ALTER AUTHORIZATION ON SCHEMA::[db_ddladmin] TO [db_datareader]
-
-
-
- GRANT VIEW DEFINITION ON [dbo].[PSYP_DataBaseBackUp] TO [db]
- GRANT ALTER ON [dbo].[PSYP_DataBaseBackUp] TO [db]
- GRANT TAKE OWNERSHIP ON [dbo].[PSYP_DataBaseBackUp] TO [db]
- GRANT CONTROL ON [dbo].[PSYP_DataBaseBackUp] TO [db]
- GRANT EXECUTE ON dbo.[PSYP_DataBaseBackUp] TO db
-
- GRANT VIEW DEFINITION ON [dbo].[PSYP_DataBaseBackUp] TO [db] WITH GRANT OPTION
- GRANT ALTER ON [dbo].[PSYP_DataBaseBackUp] TO [db] WITH GRANT OPTION
- GRANT TAKE OWNERSHIP ON [dbo].[PSYP_DataBaseBackUp] TO [db] WITH GRANT OPTION
- GRANT CONTROL ON [dbo].[PSYP_DataBaseBackUp] TO [db] WITH GRANT OPTION
- GRANT EXECUTE ON [dbo].[PSYP_DataBaseBackUp] TO [db] WITH GRANT OPTION
-
- DENY VIEW DEFINITION ON [dbo].[PSYP_DataBaseBackUp] TO [db] CASCADE
- DENY ALTER ON [dbo].[PSYP_DataBaseBackUp] TO [db] CASCADE
- DENY TAKE OWNERSHIP ON [dbo].[PSYP_DataBaseBackUp] TO [db] CASCADE
- DENY CONTROL ON [dbo].[PSYP_DataBaseBackUp] TO [db] CASCADE
- DENY EXECUTE ON [dbo].[PSYP_DataBaseBackUp] TO [db] CASCADE
-
- REVOKE VIEW DEFINITION ON [dbo].[PSYP_DataBaseBackUp] TO [db]
- REVOKE ALTER ON [dbo].[PSYP_DataBaseBackUp] TO [db]
- REVOKE TAKE OWNERSHIP ON [dbo].[PSYP_DataBaseBackUp] TO [db]
- REVOKE CONTROL ON [dbo].[PSYP_DataBaseBackUp] TO [db]
- REVOKE EXECUTE ON dbo.[PSYP_DataBaseBackUp] TO db
-
- REVOKE GRANT OPTION FOR VIEW DEFINITION ON [dbo].[PSYP_DataBaseBackUp] TO [db] CASCADE
- REVOKE GRANT OPTION FOR ALTER ON [dbo].[PSYP_DataBaseBackUp] TO [db] CASCADE
- REVOKE GRANT OPTION FOR TAKE OWNERSHIP ON [dbo].[PSYP_DataBaseBackUp] TO [db] CASCADE
- REVOKE GRANT OPTION FOR CONTROL ON [dbo].[PSYP_DataBaseBackUp] TO [db] CASCADE
- REVOKE GRANT OPTION FOR EXECUTE ON [dbo].[PSYP_DataBaseBackUp] TO [db] CASCADE
-
-
- GRANT INSERT ON [dbo].[a] TO [db] WITH GRANT OPTION
- GRANT VIEW DEFINITION ON [dbo].[a] TO [db] WITH GRANT OPTION
- GRANT VIEW CHANGE TRACKING ON [dbo].[a] TO [db] WITH GRANT OPTION
- GRANT ALTER ON [dbo].[a] TO [db] WITH GRANT OPTION
- GRANT UPDATE ON [dbo].[a] TO [db] WITH GRANT OPTION
- GRANT TAKE OWNERSHIP ON [dbo].[a] TO [db] WITH GRANT OPTION
- GRANT CONTROL ON [dbo].[a] TO [db] WITH GRANT OPTION
- GRANT DELETE ON [dbo].[a] TO [db] WITH GRANT OPTION
- GRANT SELECT ON [dbo].[a] TO [db] WITH GRANT OPTION
- GRANT REFERENCES ON [dbo].[a] TO [db] WITH GRANT OPTION
-
- INSERT
- VIEW DEFINITION
- VIEW CHANGE TRACKING
- ALTER
- UPDATE
- TAKE OWNERSHIP
- CONTROL
- DELETE
- Select
- REFERENCES
-
-
-
- VIEW DEFINITION
- ALTER
- TAKE OWNERSHIP
- CONTROL
- EXECUTE
-
-
-
- VIEW DEFINITION
- ALTER
- TAKE OWNERSHIP
- CONTROL
- REFERENCES
- EXECUTE
-
-
- VIEW DEFINITION
- ALTER
- TAKE OWNERSHIP
- CONTROL
- REFERENCES
- SELECT
-
相关阅读:
nginx实现请求的负载均衡 + Keep Alive实现nginx的高可用
理解什么是JWT(Json web token)及Python实现
TCP/UDP协议到底是什么
Redis实现分布式单点登录
Python面试题---给定一个字符串 {xxx[xxx{xxx}]xx{x[xxx]xxx{xxx}xx}x} 判断其中的 {}[]() 是否成对出现
Typora里面如何快捷改变字体颜色?
基于Docker安装关系型数据库PostgrelSQL替代Mysql
PEP8-Python编码规范
欢迎来到我的友链小屋
windows下lib和dll区别
-
原文地址:https://www.cnblogs.com/accumulater/p/6158487.html
Copyright © 2020-2023
润新知