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: 127  
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 LsAgent for Windows command line options?
by  Brandon   Go to last post Go to first unread
Last post: Yesterday at 4:49:17 PM(UTC)
Lansweeper EmailLog.txt file become big in size
by  Ary Ahmed  
Go to last post Go to first unread
Last post: 4/18/2021 10:56:58 AM(UTC)
Lansweeper LsAgent.ini
by  Orion Poplawski   Go to last post Go to first unread
Last post: 4/17/2021 4:49:12 PM(UTC)
Lansweeper LSagent force a scan
by  Orion Poplawski  
Go to last post Go to first unread
Last post: 4/17/2021 4:46:49 PM(UTC)
Lansweeper MS Edge Chromium LanSweeper Extension development
by  steveb   Go to last post Go to first unread
Last post: 4/16/2021 10:59:56 PM(UTC)
Lansweeper Office 365 v2 Scanning Error
by  DJX  
Go to last post Go to first unread
Last post: 4/16/2021 7:37:57 PM(UTC)
Lansweeper Database size growing too large
by  JTempleton   Go to last post Go to first unread
Last post: 4/16/2021 5:19:22 PM(UTC)
Lansweeper Limit New Ticket Notifications
by  Jeff WP  
Go to last post Go to first unread
Last post: 4/16/2021 4:40:43 PM(UTC)