To permanently lock a user account, you must assign a login policy with the locked option set to ON to the account. Once disabled, a user cannot connect to the SAP Sybase IQ server.
CREATE LOGIN POLICY lp_locked_users locked=ON
ALTER USER john LOGIN POLICY lp_locked_users
ALTER USER mary LOGIN POLICY lp_locked_users
John and Mary can no longer log in.