Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jeff.rathjen
Starting Member
2 Posts |
 Posted - 2014-02-20 : 15:04:52
|
| If I create a DB authenticated user like this:CREATE USER BOB WITH PASSWORD = 'Pa$$w0rd'how do I control the password options (must_change, complexity, expiration etc.)?Note, I am not talking about a login, but a user without a login, authenticated by the contained db.Thanks for any help. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-02-20 : 15:22:49
|
| Contained database users do not have these options. They are available only for logins, which uses "more extensive password policies available from Windows".Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
jeff.rathjen
Starting Member
2 Posts |
Posted - 2014-02-20 : 15:59:02
|
| Thank you. |
|
|
|
|
|
|
Password expiration for a Contained DB User