→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
bcoates
Engaged Sweeper
Hi

We're running Lansweeper on a central SQL server where DB admins are very restrictive on the permissions they grant. What are the minimum permissions I must grant to the lansweeper user to allow it to display the web40rep??? reports? Currently this user has datareader and datawriter access and nothing beyond that for the views. We had a similar issue with the procedures and had to grant this user EXECUTE permissions.

In our current situation we get errors similar to:
Report has an invalid syntax:
There is no text for object 'dbo.web40repSystemRestore'.

Thanks

Bruce
1 REPLY 1
Hemoco
Lansweeper Alumni
The user needs to be able to run:
sp_helptext

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now