Case-sensitivity of passwords is treated differently from
other identifiers.
In SAP Sybase IQ and SAP 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
SAP 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Ā® Sybase Adaptive Server Enterprise, the case-sensitivity of user IDs
and passwords follows the case-sensitivity of the server.