Case-sensitivity of passwords is treated differently from
other identifiers.
In SAP Sybase IQ and SAP Sybase SQL Anywhere®, all passwords in newly created
databases are case-sensitive, regardless of the case-sensitivity of the database. The
default user ID is DBA and the password for this user is lowercase sql.
When you rebuild an existing database, SAP Sybase IQ and
SQL Anywhere determine the case-sensitivity of the password
as follows:
- If the database was originally entered in a case-insensitive
database, the password remains case-insensitive.
- If the password was originally entered in a case-sensitive
database, uppercase and mixed-case passwords remain case-sensitive. If the
password was entered in all lowercase, then the password becomes
case-insensitive.
- Changes to both existing passwords and new passwords are
case-sensitive.
In SAP Adaptive Server® Enterprise, the case-sensitivity of user IDs
and passwords follows the case-sensitivity of the server.