PBM policy to check empty passwords

  • Dear friends,

    Please, could you give me some ideas, how to implement

    SELECT count(*) FROM sys.sql_logins WHERE PWDCOMPARE('', password_hash) = 1 ;

    As a Policy Based Management to check in our instances, currently the empty value could not be evaluated.

    I'm using an ExecuteSQL expression, but it looks like there are an error due to the character '', I have tried double '''' charaters but still no results, in my development environment I have accounts with no passwords, and I am looking if possible to audit this kind of accounts, this way any dba could check if possible bad accounts have been created.

    Thanks

  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

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

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