Create Grant Statement for All Custom Views in Microsoft SQL
On a recent project, I needed to create a new database role for some new SQL views which had been created.
Creating the role is easy enough, but to make sure all the relevant views (and there were quite a few) looked like a bigger job until I realised I could select from sys.views
and generate the grant script at the same time.
In the below script, the first highlighted section is the database…
Continue Reading azurecurve’s Article on their blog
Create Grant Statement for All Custom Views in Microsoft SQL
On a recent project, I needed to create a new database role for some new SQL views which had been created. Creating the role is easy enough, but to make sure all the relevant views (and there were quite a few) looked like a bigger job until I realised I could select from and generate the grant script at the same time.
Blog Syndicated with azurecurve’s Permission
More About This Author
Array
- 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
- Dyn365GP16 April 2024Preview of Microsoft Dynamics 365 Business Central 2024 Wave 2 Investment Areas
- Dyn365GP15 April 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Access Worksheet Pages from Mobile Phones