Permanently Locking a User Account

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.

Prerequisites

Requires the MANAGE ANY LOGIN POLICY system privilege to create/alter the login policy.
Requires the MANAGE ANY USER system privilege to assign the login policy to users.

Task

Create a login policy with the LOCKED option set to ON.
Execute the ALTER USER command to assign the login policy to a user account to be disabled.

Note: You cannot specify multiple user names in the same ALTER USER command when assigning a login policy to users.

Examples:

This command creates a new login policy named lp_locked_users with the LOCKED option set to ON:

CREATE LOGIN POLICY lp_locked_users locked=ON

These commands assign the lp_locked_users login policy to users John and Mary:

ALTER USER john LOGIN POLICY lp_locked_users

ALTER USER mary LOGIN POLICY lp_locked_users

John and Mary can no longer log in.