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 On-Prem installation. Also, you will need to create an empty database that will be accessed by ESET PROTECT On-Prem 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.