Accounts for work with the DBMS

The following tables provide information about how selecting a database management system (DBMS) affects the properties of accounts chosen for work with the DBMS.

Local DBMS is a DBMS installed on the same device as Administration Server. Remote DBMS is a DBMS installed on a different device.

Please grant all rights required for the Administration Server account before you start the Administration Server service.

SQL Server with Windows authentication and with SQL Server authentication

DBMS: SQL Server (including Express Edition) with Windows authentication

DBMS location

Local

Local

Remote

Remote

Who creates the KAV database

The installer (automatically)

Administrator (manually)

The installer (automatically)

Administrator (manually)

Account under which the installer is running

Local or domain

Local or domain

Domain

Domain

Rights of the account under which the installer is running

  • System: Local administrator rights
  • SQL Server: sysadmin role
  • System: Local administrator rights
  • SQL Server:

    public and dbcreator server-level roles

    VIEW ANY DEFINITION permission

    VIEW SERVER STATE permission (if AlwaysOn is in use)

    public role and dbo schema for master and tempdb databases

    db_owner role and dbo schema for KAV database (only if an existing KAV database is used)

  • System: Local administrator rights
  • SQL Server: sysadmin role
  • System: Local administrator rights
  • SQL Server:

    public and dbcreator server-level roles

    VIEW ANY DEFINITION permission

    VIEW SERVER STATE permission (if AlwaysOn is in use)

    public role and dbo schema for master and tempdb databases

    db_owner role and dbo schema for KAV database (only if an existing KAV database is used)

Administration Server account

  • Created automatically in KL-AK-* format
  • Local account selected by the administrator
  • Domain account selected by the administrator
  • Created automatically in KL-AK-* format
  • Local account selected by the administrator
  • Domain account selected by the administrator

Domain

Domain

Rights of the Administration Server service account

  • System: Required rights assigned by the installer
  • SQL Server: Required rights assigned by the installer
  • System: Required rights assigned by the installer
  • SQL Server:

    public server-level role

    VIEW ANY DEFINITION permission

    VIEW SERVER STATE permission (if AlwaysOn is in use)

    public role and dbo schema for master and tempdb databases

    db_owner role and dbo schema for KAV database

  • System: Required rights assigned by the installer
  • SQL Server: Required rights assigned by the installer
  • System: Required rights assigned by the installer
  • SQL Server:

    public server-level role

    VIEW ANY DEFINITION permission

    VIEW SERVER STATE permission (if AlwaysOn is in use)

    public role and dbo schema for master and tempdb databases

    db_owner role and dbo schema for KAV database

DBMS: SQL Server (including Express Edition) with SQL Server authentication

DBMS location

Local

Remote

Who creates the KAV database

Administrator (manually) or the installer (automatically)

Administrator (manually) or the installer (automatically)

Account under which the installer is running

Local

Domain

Rights of the account under which the installer is running

  • System: Local administrator rights
  • SQL Server: Installer account does not require access to SQL Server
  • System: Local administrator rights
  • SQL Server: Installer account does not require access to SQL Server

Administration Server service account

Local or domain

Domain

Rights of the Administration Server service account

  • System: Required rights assigned by the installer
  • SQL Server: Administration Server service account does not require access to SQL Server
  • System: Required rights assigned by the installer
  • SQL Server: Administration Server service account does not require access to SQL Server

Additional information

The administrator explicitly specifies in the installer a SQL Server internal account that requires the sysadmin role.

The administrator explicitly specifies in the installer a SQL Server internal account that requires the sysadmin role.

MySQL

DBMS: MySQL

DBMS location

Local or remote

Local or remote

Who creates the KAV database

The installer (automatically)

Administrator (manually)

Account under which the installer is running

Local or domain

Local or domain

Rights of the account under which the installer is running

  • System: Local administrator rights
  • MySQL Server: Installer account does not require access to MySQL
  • System: Local administrator rights
  • MySQL Server: Installer account does not require access to MySQL

Administration Server service account

Local or domain

Local or domain

Rights of the Administration Server service account

  • System: Required rights assigned by the installer
  • MySQL Server: Administration Server service account does not require access to MySQL
  • System: Required rights assigned by the installer
  • MySQL Server: Administration Server service account does not require access to MySQL

Additional information

The administrator explicitly specifies in the installer a SQL Server internal account that requires root access.

The administrator explicitly specifies in the installer a MySQL internal account that requires GRANT ALL for the KAV database and SELECT, SHOW VIEW, PROCESS for the system tables.

Page top