cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
davidk
Engaged Sweeper
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.
1 REPLY 1
FrankSc
Lansweeper Tech Support
Lansweeper Tech Support
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.