
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-06-2010 12:20 AM
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
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
Labels:
- Labels:
-
Archive
1 REPLY 1

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-06-2010 11:59 AM
The user needs to be able to run:
sp_helptext
sp_helptext
