Administration Guide

User IDs and Passwords

When creating a user ID or password, the name you create:

Cannot be any of the following:
- USERS, ADMINS, GUESTS, PUBLIC, LOCAL, or any SQL reserved word listed in the SQL Reference.
Cannot begin with:
- SQL, SYS, or IBM
Can include:
- A through Z
  Note: Some operating systems allow case-sensitive user IDs and passwords. You should check your operating system documentation to see if this is the case.
- 0 through 9
- @, #, or $
User IDs cannot exceed 30 characters.

Note:

You may be required to perform password maintenance tasks. Since such tasks are required at the server, and many users are not able or comfortable working with the server environment, carrying these tasks can pose a significant challenge. DB2 UDB provides a way to update and verify passwords without having to be at the server. For example, DB2 for OS/390 Version 5 supports this method of changing a user's password. If an error message SQL1404N "Password expired" is received, use the CONNECT statement to change the password as follows:

   CONNECT TO <database> USER <userid> USING <password>
      NEW <new_password> VERIFY <new_password>

The "Password change" dialog of the DB2 Client Configuration Assistant (CCA) can also be used to change the password. For more information about these methods of changing the password, refer to the SQL Reference and the CCA online help.

[ Top of Page | Previous Page | Next Page ]