数据库登录的密码策略是什么 [英] What's the password policy for a db login

问题描述

服务器登录名和数据库用户的密码策略是什么?

what's the password policy for a server login and database user ?

密码要求?

帐户锁定失败尝试?

密码过期日期?

…..

谢谢

推荐答案

此链接说明了Azure SQL登录的确切情况:

This link explains what exactly happens with Azure SQL logins:

SQL数据库管理登录名

Azure SQL数据库逻辑服务器(创建登录名)

支票政策和支票到期期限不受支持.如果指定了 MUST_CHANGE ， CHECK_EXPIRATION 和 CHECK_POLICY 必须设置为 开启. 否则，该语句将失败.

check Policy and check expiration are not supported. If MUST_CHANGE is specified, CHECK_EXPIRATION and CHECK_POLICY must be set to ON. Otherwise, the statement will fail.

Msg 40517, Level 16, State 1, Line 4
Keyword or statement option 'check_expiration' is not supported in this version of SQL Server.


Msg 40517, Level 16, State 1, Line 3
Keyword or statement option 'check_policy' is not supported in this version of SQL Server.

Msg 40517, Level 16, State 1, Line 8
Keyword or statement option 'must_change' is not supported in this version of SQL Server.

这篇关于数据库登录的密码策略是什么的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！