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 manual.
Cannot begin with:
- SQL, SYS, or IBM
Other characters can include:
- A through Z
  Note: Some operating systems allow case-sensitive user IDs and passwords. You should check with your operating system information to see if this is the case.
- 0 through 9
- @, #, or $

Note:

You may be required to perform password maintenance tasks. Since such tasks are required at the server, and many of the 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, then to change the password use the CONNECT statement as follows:

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

The "Password change" dialogue of the DB2 Client Configuration Assistant (CCA) may also be used to make a change to the password. See the SQL Reference and the CCA online help for further information on these methods to change the password.

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]