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
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.
Note: If you are using
DB2 on windows, the LNTUSER must be created and added to your Windows
user group.