Database permissions

We recommend that the Transact database service account be assigned db_ownerpermissions. This is because Transact patch installers may alter the existing database. If this occurs, it may be necessary to create a new database table or modify the schema after an upgrade or running a patch installer.

Transact performs the following operations on the database server:

  1. Transact connects with the database server and creates an Application and reporting database. Transact populates tables in the reporting database at the same time.
  2. Transact creates an account with the name ephesoft and gives all permissions on the Application and reporting databases to this account.
  3. Once installation and database creation are complete, Transact connects with the database server using the ephesoft login. Transact creates tables in the Application database.
  4. Transact performs SELECT, INSERT, DELETE and UPDATE operations on tables.