By default, users can view Excel reports and data connections only if they have administrative credentials on the server that is running SQL Server and if they have access to the network share. Since this isn't a normal setup, users typically need reporting privileges in SQL Server before they can view the Microsoft Dynamics GP data that is displayed in data connections and Excel reports.
There are three areas of security around Excel reports deployed to a network share or local drive:
We'll spend a few minutes with each one.
Realistically, network share security is normally going to be set by a network administrator. To shortcut this for administrators, the minimum required security on the shared folder is:
Change for the share tab
Read for the security tab
Now, for those of you who want the version that is longer than a Latvian wiener dog:
In Windows Explorer, right-click...