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

    • Setting up the Automated Conflict Export and Email

      Setting up the Automated Conflict Export and Email Start “Task Scheduler” on the appropriate Server (Application, SQL, dedicated, etc..) Select the Task Scheduler Library and right click and select “Create New Task” General Tab Name Enter the name to ...

    • 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 2025b-SP0 (build 1.25.20.6036)

      New and/or Adjusted Functionality Conflict Mitigation Request The ability to request a conflict mitigation, initiated from the conflict report. This request can be routed for approval and upon approval, will result in a Control, Resolution Rule. This ...