Configuring proper user rights on repository/database

Configuring proper user rights on repository/database

This document explains the official database rights that needs to be given to the EZ-Control Admin Center users. This information is applicable to the following software:
  • EZ-Compliance Admin Center
  • EZ-Workflow Admin Center
  • EZ-Dashboard Admin Center
  • EZ-Language
  • DEM Import Module (also known as ImportBPDA)
Database connections are support in both SQL and Windows authentication.

The best and easiest configuration is to grant DBO Owner (DBO) rights to every users of the Admin Center software. Note that this is not needed for users of the various Web-Portals.

If your organization requires tighter security, find below the minimum required rights:
  • Alter
  • Authenticate
  • Connect
  • Create Table
  • Drop Table
  • Delete
  • Execute
  • Insert
  • Select
  • Update

    • Related Articles

    • Lock out user

      unlock user procedure

    • Error while connecting or creating connection to a Repository

      There could be several reasons for a failed connection to a repository (database) either while Connecting or Adding a repository. 1) You are attempting to connect to a database... Causes: The installed Admin Center version is not compatible with this ...

    • Release Notes EZ-Compliance 2022b (build 1.22.20.4543)

      New and/or Adjusted Functionality Added "creation" logs to Access Point's log when Access Points are created (TICKET 1980) At various places in the Application where an Access Point could be created the Creation event was not logged in the Access ...

    • Release Notes EZ-Compliance 2021b (build 1.21.20.3987)

      New and/or Adjusted Functionality openERP Import - multiple descriptions same Diagram/Process Object (TICKET 1806) When importing authorizations any Master Data object which is included in the import file, but not present in the Master Data, is ...

    • Release Notes EZ-Compliance 2020b-SP0 (build 1.20.20.3445)

      New and/or Adjusted Functionality PAR initiation service will now report if one or more authorization(s) could end up having no Reviewer (TICKET 1520)  Upon initiation of a PAR Cycle, the reviewers per step are determined. In the situation that the ...