Create a Database Role to Grant Access to Views for Reporting

Microsoft SQL ServerToo 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

Author: Ian Grieve

Share This Post On