在哪里可以查看是否已向可用性组授予CREATE ANY DATABASE权限 [英] Where can you view if CREATE ANY DATABASE permission has been granted to Availability Group

问题描述

我们正在尝试创建一个验证步骤，以确保AutoSeeding按预期工作。我正在寻找可以查询的地方，以确定是否为可用性组提供了以下权限，但似乎无法找到它。它似乎不是
在SSMS内的服务器级别权限中，也不在任何AlwaysOn DMV中。 任何人都可以帮忙吗？ 

更改可用性组[MY_AG]授予创建任何数据库

GO

---

Andre Porter

解决方案

您可能意味着 

GRANT
创建任何数据库
ON AVAILABILITY GROUP :: MY_AG  TO
USER;

SELECT * FROM sys.server_permissions

WHERE permission_name ='CREATE ANY DATABASE'

We're attempting to create a validation step that ensures AutoSeeding will work as intended. I'm looking for the place I can query to determine if the below permission is in place for the Availability Group and can't seem to find it. It does not appear to be in the Server level permissions within SSMS nor in any of the AlwaysOn DMVs.  Can anyone help? 

ALTER AVAILABILITY GROUP [MY_AG] GRANT CREATE ANY DATABASE
GO

---

Andre Porter

解决方案

You probably mean 

GRANT CREATE ANY DATABASE ON AVAILABILITY GROUP::MY_AG TO USER;

SELECT * FROM sys.server_permissions
WHERE permission_name='CREATE ANY DATABASE'

这篇关于在哪里可以查看是否已向可用性组授予CREATE ANY DATABASE权限的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！