Notification

Icon
Error

lansweeperuser sql database permissions - lansweeperuser sql database permissions

Posted: Thursday, February 25, 2021 11:54:38 PM(UTC)
David K.

David K.

Member Original PosterPosts: 1
0
Like
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
#1FrankSc Member Administration Posts: 131  
posted: 3/3/2021 8:54:22 AM(UTC)
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.

Active Discussions

Lansweeper USB printers with toner levels
by  rader   Go to last post Go to first unread
Last post: Today at 12:29:27 AM(UTC)
Lansweeper Showing all assets without a department
by  Andy.S  
Go to last post Go to first unread
Last post: Yesterday at 8:30:43 AM(UTC)
Lansweeper Patch Volume Across Fleet
by  darren.kimber   Go to last post Go to first unread
Last post: Yesterday at 8:29:33 AM(UTC)
Lansweeper Count by Department
by  Brandon  
Go to last post Go to first unread
Last post: 4/21/2021 7:42:00 PM(UTC)
Lansweeper Adding computer type to Windows 10 report
by  Brandon  
Go to last post Go to first unread
Last post: 4/19/2021 6:38:45 PM(UTC)
Report Center Hardware Inventory
by  Cori   Go to last post Go to first unread
Last post: 4/16/2021 4:05:02 PM(UTC)
Lansweeper Windows Activation
by  Hendrik.VE  
Go to last post Go to first unread
Last post: 4/16/2021 4:01:47 PM(UTC)