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.