Dedicated database user account

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

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

•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/8.0/en/grant.html.

•Microsoft SQL Server database-level roles: An ESET PROTECT 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

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