Overview
M-Files needs two users to host a vault in MS SQL server.
- Administrator user - either a sysadmin or DBO of the M-Files database. This user can be used with multiple vaults.
- Basic user - this must be unique for each vault and may also be set as automatic (requires that the DBO user is a sysadmin). This user may not be the same as the Administrator user.
This article provides some more details on the operations they perform.
Details
The Administrator user needs to have either a sysadmin role on the server-level, or the db_owner role on the M-Files database level. This user is used do perform higher level operations in the M-Files database, including modifying the structure of the database and granting access to the basic user. If the user is a sysadmin, it can enable the basic user being automatic and can also better manage the database. If the Administrator user cannot have the sysadmin role, please see the How to Configure M-Files to Operate Without Sysadmin Role in MS SQL Server article as some additional steps are needed.
The Basic user is used for all "daily" operations such as SELECT, INSERT, DELETE, UPDATE queries - it needs to be able to read and write data to the vault database. The basic user only needs login access to the SQL server if created manually, M-Files will automatically take care of granting it the necessary roles and access rights. Any access to any databases should not be granted to this user if created manually. The Basic user must be different from the db_owner user. If you create it manually, make sure it is unique for each vault.
