查询以检查辅助副本是否具有“创建数据库”权限 [英] Query to check if Secondary Replica has 'Create Database' right
问题描述
我正在考虑为AlwaysOn使用自动播种功能。根据BOL( https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/automatic-seeding-secondary-replicas?view = sql-server-2017) ,我需要授予可用性
组"创建数据库"权限。 是否有任何查询可以检查副本是否已经拥有权利或现在,而不是空白地运行授予权限?我检查了服务器角色(dbcreator),但没有快乐。这是有道理的,因为AlwaysOn Group没有
有登录。任何人都可以点亮它吗?
I am thinking of using autoseeding for our AlwaysOn. According to BOL ( https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/automatic-seeding-secondary-replicas?view=sql-server-2017 ) , I need to grant availability group the 'Create Database' right. Is there any query that can check if the replica already has the right or now , instead of blankly run the grant permission ? I checked server role ( dbcreator ), but no joy. This makes sense as the AlwaysOn Group doesn't have a login. Can anyone please cast light on it ?
非常感谢!
推荐答案
嗨兰兰,
请检查以下查询:
select *from sys.database_permissions where permission_name in ('CREATE DATABASE', 'CREATE ANY DATABASE')
最好的问候,
Teige
这篇关于查询以检查辅助副本是否具有“创建数据库”权限的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!