Permissions for MySQL

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 migrations

For the MySQL server automatic schema creation creation to work correctly with HCL Traveler on MySQL, the user needs the following permissions:
  • The DB Login User's From Host needs to include the Traveler Server.

  • CREATE, ALTER, INDEX, DROP

  • INSERT, UPDATE, SELECT and DELETE

DDL schema

For the DDLs that are applied without any customization, the LNTUSER created by the scripts includes the following permissions that allow the TRAVELER database and schema to perform HCL Traveler operations:
  • The DB Login User's From Host needs to include the Traveler Servers.
  • 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:

  • CREATE, ALTER, INDEX, DROP