Permissions for DB2 Enterprise Database

For DB2 Enterprise Database, you must assign the proper permissions for the autoschema or DDL schema methods to work.

Autoschema

For the DB2 autoschema 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 IBM Traveler supplied DDL scripts without any customization, then the LNTUSER, by default, includes the following permissions to the TRAVELER database for performing IBM 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.