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 $

[ DB2 List of Books | Search the DB2 Books ]