Permissions for DB2 Enterprise Database

For the automatic schema migration or DDL schema methods to work, you must assign the proper permissions to the DB Login User that is used to connect from the Traveler Server.

Automatic schema migration

For the DB2 automatic schema migration creation to work correctly, it is recommended that you add the operating system user to the DB2USERS group (Windows) and assign him or her the following database permissions.
  • CONNECT
  • Create/Alter database
  • Create/Alter/Drop schema or table
  • INSERT, UPDATE, SELECT and DELETE
Additional database permissions are required for tell traveler dbmaint to execute the database actions. The user needs the following permissions:
  • GRANT DBADM ON DATABASE TO < DATABASE_USER >

DDL schema

If you are using HCL Traveler supplied DDL scripts without any customization, then the LNTUSER, by default, includes the following permissions to the TRAVELER database for performing HCL Traveler operations:
  • CONNECT
  • INSERT, UPDATE, SELECT and DELETE
No other specific permissions are required. The LNTUSER does not include any schema privileges. As a result, this user will not be able to alter the schema. Additional database permissions are required for tell traveler dbmaint to execute the database actions. The user needs the following permissions:
  • GRANT DBADM ON DATABASE TO < DATABASE_USER >
Note: If you are using DB2 on windows, the LNTUSER must be created and added to your Windows user group.