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
- Dyn365GP3 February 2024SQL Query on Matomo Database to Calculate the Number of Visits to Each Page
- Dyn365GP2 February 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Use Virtual Tables to Expose More Business Central Data in Dataverse
- Dyn365GP2 February 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Manage Work Orders in Field Service, Invoice Them in Business Central
- Dyn365GP2 February 2024In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Manage Consignment Stock at a Customer Location