天蓝色的用户错误 [英] azure singe user error

问题描述

我希望Azure数据库尽可能安全。 所以我的一个想法是让数据库以单用户模式运行。 当我尝试更改设置时，我收到一个错误，即无法在单用户模式下设置参与镜像或可用性
组的数据库。 我从来没有设置过这样的东西所以我不明白为什么我会收到这个错误。  

I have an Azure database that I want to keep as secure as possible.  So one of my thoughts was having the database run in single user mode.  When I tried changing the setting I got an error that databases participating in mirroring or availability group cannot be set in single user mode.  I never set anything like that up so I don't understand why I am getting that error.  

推荐答案

SINGLE_USER不是一个可用的选项用于Azure SQL数据库。如文档（https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-database-transact-sql-set-options?view=azuresqldb-current）中所述，选项是RESTRICTED_USER和MULTI_USER。

SINGLE_USER is not an available option for Azure SQL Database. As detailed in the documentation (https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-database-transact-sql-set-options?view=azuresqldb-current), the options are RESTRICTED_USER and MULTI_USER.

请注意，SINGLE_USER用于管理维护，而不是作为安全功能。单用户模式下只允许一个连接。安全性通过网络和访问管理完成（ https://docs.microsoft.com/en-us/azure/sql-database/sql-database-security-overview ）。 / span>

Note that SINGLE_USER is intended for administrative maintenance, not as a security feature. Only a single connection is allowed in single user mode. Security is accomplished through network and access management (https://docs.microsoft.com/en-us/azure/sql-database/sql-database-security-overview).

这篇关于天蓝色的用户错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！