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

The MANAGE ANY LOGIN POLICY system privilege to create or alter the login policy.
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. John and Mary can no longer log in.

ALTER USER john LOGIN POLICY lp_locked_users
ALTER USER Mary LOGIN POLICY lp_locked_users