Post reply

verify "enforce password policy" is set

  • May 11, 2009 at 3:30 pm

    #209172

    I'm trying to figure out how to verify, via scripting, if an account has "enforce password policy" and "enforce password expiration" set. I looked at LOGINPROPERTY but it only tells me if the password needs to be changed, is expired, or things relating to the immediate and not policy settings on the account.

    I've checked server_principals, server_role_members (those two together may get me what I need for something else), sysusers. I've looked at the BOL for sp_helpuser and sp_helplogins.

    I see where you can set the values when you create or alter the account but I just want to see if it is set, and it has to be in a script because this stuff is automatically and periodically executed and the results emailed to various people.

    Does anyone have suggestions on where I might find this kind of account information?

  • May 11, 2009 at 3:44 pm

    #992509

    sys.sql_logins

    http://msdn.microsoft.com/en-us/library/ms174355(SQL.90).aspx

  • May 11, 2009 at 3:50 pm

    #992513

    Thanks Steve!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply