title: Is there a way to find all users with disabled passwords on redshift
body: <p>I'm trying to find all users that have been created with 'disabled' passwords in redshift. We are looking to maintain users syncing from ldap. They will be created with disabled passwords so they cannot log in directly and we want to list them so they can be removed when longer required.</p>
  <pre><code>create user no_pass_user with password disable
  </code></pre>
  <p>I've tried querying pg_user where passwd is null etc, but nothing</p>
  <pre><code>select * from pg_user where passwd is null or passwd = 'disable' or passwd = '' ;
  </code></pre>
  <p>I could use expiry date etc, but would prefer disabled password if possible.</p>
  <p>Thanks in advance</p>