Permissions for Enterprise SQL server
automatic schema migration
For the SQL server automatic schema migration creation to work correctly with HCL 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 HCL 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 HCL 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. Additional database permissions are required for tell traveler dbmaint to execute the database actions. The user needs the following permissions:
- ALTER AUTHORIZATION ON SCHEMA :: < DATABASE_SCHEMA > TO < DATABASE_USER >
- GRANT view database state TO < DATABASE_USER >