Dedicated database user account

If you do not wish to use an SA account (MS SQL) or root account (MySQL), you can create a dedicated database user account. This dedicated user account will be used to access the ESMC database only. We recommend that you create a dedicated database user account within your database server before starting ESET Security Management Center installation. Also, you will need to create an empty database that will be accessed by ESET Security Management Center using this dedicated user account.

details_hoverNOTE

There is a minimum set of privileges that must to be granted to a dedicated database user account.

You can find detailed guide how to set up your database and user account for both MS SQL and MySQL in our Knowledgebase article.

MySQL user privileges:

ALTER, ALTER ROUTINE, CREATE, CREATE ROUTINE, CREATE TEMPORARY TABLES, CREATE VIEW, DELETE, DROP, EXECUTE, INDEX, INSERT, LOCK TABLES, SELECT, UPDATE, TRIGGER - for more information about MySQL privileges, see http://dev.mysql.com/doc/refman/5.7/en/grant.html.

Microsoft SQL Server database-level roles:

An ESMC database user must be a member of the db_owner database role. For more information about Microsoft SQL Server database-level roles, see https://msdn.microsoft.com/en-us/library/ms189121%28v=sql.100%29.aspx