Permissions for Enterprise SQL server
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 migration
- 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
- 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.