title: DB2 revoke user privileges from a database from multiple users
body: <p>I want to revoke all privileges from all users but one from a database.
  DB2 10.5 LUW</p>
  <p>I was thinking along the lines of:</p>
  <pre><code> db2 &quot;revoke all on database from user IN (select grantee from syscat.dbauth where grantee not IN 'SAFEUSER')&quot;
  </code></pre>
  <p>but I can't get it to work.</p>
  <p>Any ideas?</p>