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
Create a Database Role to Grant Access to Views for Reporting
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 n…
Blog Syndicated with azurecurve’s Permission