Password Policy Query - SQL Server Forums

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 2005 Forums

SQL Server Administration (2005)

Password Policy Query

Author

Topic

tbrothers
Yak Posting Veteran

83 Posts

Posted - 2012-04-03 : 10:40:50

Hello,

Is there a query that will show logins that are NOT set to enforce the password policy and password expiration?

Thanks,
Terry

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2012-04-03 : 11:37:51

[code]SELECT is_policy_checked
FROM sys.sql_logins
WHERE name = 'SQL Login Name Here'[/code]

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2012-04-03 : 11:39:31

For returning all unchecked


SELECT	name
FROM	sys.sql_logins
WHERE	is_policy_checked = 0

tbrothers
Yak Posting Veteran

83 Posts

Posted - 2012-04-04 : 08:20:50

Perfect - Thank you!

Thanks,
Terry

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources