By default, users can view Excel reports and data connections only if they have administrative credentials on the server that is running the SQL Server and if they have access to the network share. Since this isn't a normal setup, users typically need reporting privileges in the 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:
Security to the network share/local folder
Security at the database level
Security around Excel
We'll spend a few minutes on each one.
Realistically, network share security is normally going to be set by a network administrator. To make a shortcut for administrators, the minimum required security on the shared folder is:
Change option for the share tab
Read option for the security tab
Now, for those of you who want the version that is longer than a (as Mark Polino would say...