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.
Additional database permissions are required for tell traveler dbmaint to
execute the database actions. The user needs the following permissions:- CONNECT
- Create/Alter database
- Create/Alter/Drop schema or table
- INSERT, UPDATE, SELECT and DELETE
- 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.