Users

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.
• Case-Sensitivity of User IDs and Passwords
  Case-sensitivity of passwords is treated differently from other identifiers.
• Creating a New User
  Create a new user ID.
• Deleting a User
  Remove a user ID from the database.
• Changing a User's Password
  Change the password of another user.
• Converting a User-Extended Role Back to a User
  You can convert a user-extended role back to a regular user.
• 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.
• Unlocking User Accounts
  Unlock a user account.
• 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.