Permissions error exporting Microsoft Dynamic GP SmartList Object

Microsoft Dynamics GPA client recently reported a problem whereby users were no longer able to export a SmartList favourite to Excel as they were receiving a permissions error when the Excel file opened:

The SELECT permission was denied on the object 'uv_AZRCRVBudgetByMonth', database LIVE', schema 'dbo'

I did some checking and realised that the problem was that the file being opened when the user tried to do an…

Continue Reading Ian Grieve’s Article on their blog

Permissions error exporting Microsoft Dynamic GP SmartList Object

A client recently reported a problem whereby users were no longer able to export a SmartList favourite to Excel as they were receiving a permissions error when the Excel file opened: The SELECT permission was denied on the object ‘uv_AZRCRVBudgetByMonth’, database LIVE’, schema ‘dbo’ I did some checking and realised that the problem was that the file being opened when the user tried to do an export, was named like a Refreshable Excel report; a little more checking showed that there was a Refreshable Excel report of that name using the view from the SmartList.

Blog Syndicated with Ian Grieve’s Permission

Author: Ian Grieve

Share This Post On