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:

    Server-level roles: public and dbcreator

    VIEW ANY DEFINITION permission

    VIEW SERVER STATE permission (if AlwaysOn is set)

    For master and tempdb databases: public role and dbo schema

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

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

    Server-level roles: public and dbcreator

    VIEW ANY DEFINITION permission

    VIEW SERVER STATE permission (if AlwaysOn is set)

    For master and tempdb databases: public role and dbo schema

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

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:

    Server-level role: public

    VIEW ANY DEFINITION permission

    VIEW SERVER STATE permission (if AlwaysOn is set)

    For master and tempdb databases: public role and dbo schema

    For KAV database: db_owner role and dbo schema

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

    Server-level role: public

    VIEW ANY DEFINITION permission

    VIEW SERVER STATE permission (if AlwaysOn is set)

    For master and tempdb databases: public role and dbo schema

    For KAV database: db_owner role and dbo schema

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