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:
- Transact connects with the database server and creates an Application and reporting database. Transact populates tables in the reporting database at the same time.
- Transact creates an account with the name ephesoft and gives all permissions on the Application and reporting databases to this account.
- Once installation and database creation are complete, Transact connects with the database server using the ephesoft login. Transact creates tables in the Application database.
- Transact performs SELECT, INSERT, DELETE and UPDATE operations on tables.