Select all user views and create GRANT SELECT TO DYNGRP statement

I 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

Select all user views and create GRANT SELECT TO DYNGRP statement

I 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 Ex‎…

Blog Syndicated with Ian Grieve’s Permission