Description

We were faced with the situation of having 485+ views out of a total of 690+ views that needed to be updated to grant access to 30 new roles that were created in our VSA (Part of our need to implement granular access permissions).

With input from Kaseya development, our applications developer (a bit of a T-SQL Guru IMHO) rolled this elegant SQL script that will update the ACLs in bulk ONLY if the permissions do not already exist for the specified view.