Service Account Permissions - Windows#

One or more Windows service accounts are used to run Colectica Repository. This section describes the file and sql permissions required by the designated service accounts.

Colectica Repository#

  • Requires read access to the Colectica Repository database for ColecticaGuest functions

  • Requires write access to the Colectica Repository database for ColecticaUser and ColecticaAdministator functions

Web Portal#

  • Requires read access to the Colectica Repository database for all viewing functions

  • Requires partial write access to the Colectica Repository database for optional functions

    • Requires write access to the event table for logging

    • Requires write access to the permission, repository, and repository_setting for administration

    • Requires write access to the user_comment and user_rating for user social functions

Colectica Workflow Service (Optional)#

  • Requires read and write access to the Colectica workflow database

  • Requires read access to all source Colectica Repository databases

  • Requires write access to all target Colectica Repository databases

  • Requires read and write access to a temporary metadata directory

Colectica Workflow Website (Optional)#

  • Requires read and write access to the Colectica workflow database

  • Requires read and write access to a temporary metadata directory

  • Requires read access to all source and target Colectica Repository databases