Permissions for Enterprise SQL server

For SQL servers, you must assign the proper permissions for the autoschema or DDL schema methods to work.

Autoschema

For the SQL server autoschema creation to work correctly with IBM Traveler on SQL, the user needs to have the following permissions:
  • CONNECT
  • Create/Alter database
  • Create/Alter/Drop schema or table
  • INSERT, UPDATE, SELECT and DELETE

It is recommended that you make the SQL user own the database by assigning him or her the db_owner role, which will automatically grant these permissions. The SQL server, by default, assigns the user the "dbo" schema, which is what the IBM Traveler server uses for its schema operations.

DDL schema

For the DDL's that are applied without any customization, the LNTUSER created by the scripts includes the following permissions to the TRAVELER database and schema for performing IBM Traveler operations:
  • CONNECT
  • INSERT, UPDATE, SELECT and DELETE

The DDL scripts automatically assign the LNTUSER to the schema. No other specific permissions are required. The LNTUSER does not include any schema privileges, and this user will not be able to alter the schema.