EXEC sp_addrolemember N'db_owner', N'db'----将db 设置为 db_owner 角色中的一员EXEC sp_droprolemember N'db_owner', N'db'----将db 从 db_owner 角色 去除ALTER AUTHORIZATION ON SCHEMA::[db_datareader] TO dbs ----给db 赋予 拥有 db_datareader 架构ALTER AUTHORIZATION ON SCHEMA::[db_datareader] TO db --- 修改 db_datareader 架构的所有者为dbALTER AUTHORIZATION ON SCHEMA::[db_ddladmin] TO [db_datareader] ---修改 db_datareader 角色所拥有的架构--- 赋予 《授予 XX 权限》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--执行---赋予 《具有授予XX权限》---如果直接给 具有授予权限 则 默认给予了XX权限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 ----拒绝XX权限DENY VIEW DEFINITION ON [dbo].[PSYP_DataBaseBackUp] TO [db] CASCADEDENY ALTER ON [dbo].[PSYP_DataBaseBackUp] TO [db] CASCADEDENY TAKE OWNERSHIP ON [dbo].[PSYP_DataBaseBackUp] TO [db] CASCADEDENY CONTROL ON [dbo].[PSYP_DataBaseBackUp] TO [db] CASCADEDENY EXECUTE ON [dbo].[PSYP_DataBaseBackUp] TO [db] CASCADE---收回XX权限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--执行---收回XX具有授予权限REVOKE GRANT OPTION FOR VIEW DEFINITION ON [dbo].[PSYP_DataBaseBackUp] TO [db] CASCADEREVOKE GRANT OPTION FOR ALTER ON [dbo].[PSYP_DataBaseBackUp] TO [db] CASCADEREVOKE GRANT OPTION FOR TAKE OWNERSHIP ON [dbo].[PSYP_DataBaseBackUp] TO [db] CASCADEREVOKE GRANT OPTION FOR CONTROL ON [dbo].[PSYP_DataBaseBackUp] TO [db] CASCADEREVOKE GRANT OPTION FOR EXECUTE ON [dbo].[PSYP_DataBaseBackUp] TO [db] CASCADE--------给表赋 权限--- 赋予 《具有授予XX权限》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 ---选择
如果觉得《SQL SERVER 存储过程 表 视图 函数的权限》对你有帮助，请点赞、收藏，并留下你的观点哦！
