User management includes the creation and deletion of user IDs, as
well as password management.
DBA User
The DBA user is the default user created when a new SAP Sybase IQ database is created.
Super-User
Super-users can exercise any system privilege and administer any role; they can perform any privileged operation in the system. Role-based security does not require a super-user to maintain the database; the DBA user might not be a super-user.
Increase Password Security
Passwords are an important part of any database security system. There are several options for increasing password security.
Passwords in the Database
As of version 15.0, SAP Sybase IQ uses SHA256 to hash passwords. Passwords are stored in UTF-8.
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.
Automatic Unlocking of User Accounts
A lockdown of some or all database services may occur if all administrative users with the MANAGE ANY USER system privilege are locked out of the database due to failed login attempts.