Too many times as a consultant I have discovered that users have been grant full access to a database when they only need select permissions on a handful of SQL views or tables. Whenever I create a new SQL view for a client I will create a database role to go with it, as best practice is to only grant the minimum permissions needed.
Below is a script example of creating a database role and…
Continue Reading azurecurve’s Article on their blog
https://www.azurecurve.co.uk/2022/09/create-a-database-role-to-grant-access-to-views-for-reporting/
Blog Syndicated with azurecurve’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
