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 Cloud relay data stored time
by  Inaki Gomez   Go to last post Go to first unread
Last post: Today at 10:57:12 AM(UTC)
Lansweeper Scan UPS
by  FrankSc  
Go to last post Go to first unread
Last post: Today at 10:54:23 AM(UTC)
Lansweeper I Need a List of Hostname
by  Nicolas Burd   Go to last post Go to first unread
Last post: Yesterday at 7:31:34 PM(UTC)
Lansweeper User View Customization
by  DarkOne77  
Go to last post Go to first unread
Last post: Yesterday at 5:26:25 PM(UTC)
Lansweeper Acknowlege from Alerts
by  Brandon   Go to last post Go to first unread
Last post: Yesterday at 4:44:06 PM(UTC)
Lansweeper Helpdesk Custom field for working hours
by  Robert Tecklenburg  
Go to last post Go to first unread
Last post: Yesterday at 9:48:28 AM(UTC)
Lansweeper LsAgent.ini
by  IT-EPUDF   Go to last post Go to first unread
Last post: 4/21/2021 11:26:00 PM(UTC)
Lansweeper Lansweeper cisco LWAPP's
by  Scott G  
Go to last post Go to first unread
Last post: 4/21/2021 7:43:18 PM(UTC)