lansweeperuser sql database permissions

[davidk]

The default local sql account created during lansweeper installation "lansweeperuser" is assigned DBowner permissions of the lansweeper database.

Is the DBowner permissions still required after the installation? Can we reduce the sql permission on the database to DB_datawriter/DB_datareader for the local lansweeperuser sql account after the installation?

What level of sql permissions does the "lansweeperuser" require during version upgrades?

We are trying to implement minimum permissions for all our application and sql permissions required.

Thank you in advance.

[FrankSc]

Hello,

For optimal functionality, we recommend leaving the permissions as they are. The Lansweeperuser is technically the only user that communicates with the database and requires these permissions to apply necessary updates in the database.

Upon the initial installation, it is the user specified in the setup steps that creates the database. But later when running updates, update scripts are executed by the scanning service, meaning Lansweeperuser. These update could require table updates, creation of tables etc. For these steps DBOwner will be required.