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
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
More About This Author
Array
- Dyn365GP19 April 2024MADIC dynamics Knowledge Hub Webinars: Jet Reports & Business Central
- Dyn365GP19 April 2024In Microsoft Dynamics 365 Business Central (Administration), how do I… Rename a Company
- Dyn365GP18 April 2024In Microsoft Dynamics 365 Business Central (Administration), how do I… Share a Saved List View
- Dyn365GP17 April 2024Splitting a Table on a Microsoft Dynamics 365 Business Central Word Template