Users

User management includes the creation and deletion of user IDs, as well as management of passwords.

• DBA User
  The DBA user is the default user created when a new SAP Sybase IQ database is created.
• Super-User
  Super-users are users that 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, and the DBA user may not be a super-user.
• Increase Password Security
  Passwords are an important part of any database security system. There are several options available to increase password security.
• Passwords in the Database
  SAP Sybase IQ 15.0 or later use 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 lock-down 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.