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.

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 Password expiration for a Contained DB User

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 Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

jeff.rathjen
Starting Member

2 Posts

Posted - 2014-02-20 : 15:59:02
Thank you.
Go to Top of Page
   

- Advertisement -