VSA

Bulk Update View ACLs

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.

Class
Developer
  • Name: Pedro P. Polakoff III
  • Company: CWPS
  • Website: http://www.cwps.com
  • Contact Developer
  • Summary
  • VSA
  • 8 Downloads
  • Version: 9.5
  • Released on September 20th, 2018
  • Reviews

    VSA has no reviews.

    Discussion

    VSA has no comments.