Select all user views and create GRANT SELECT TO DYNGRP statement

Microsoft Dynamics GPI have a Microsoft Dynamics GP project deployment coming up soon for a client project for which a number of SQL views have been created; I can easily grab a create script for the views from Object Explorer Details in SQL Server Management Studio, but I also need to create the grant statement to give permissions to Dynamic GP users to use the SmartLists Builder objects which use these views.

Continue Reading Ian Grieve’s Article on their blog

https://www.azurecurve.co.uk/2020/08/select-all-user-views-and-create-grant-select-to-dyngrp-statement/

Blog Syndicated with Ian Grieve’s Permission

Author: Ian Grieve

Share This Post On
Share via
Copy link
Powered by Social Snap