Useful in dev environments when you need to periodically assign execute permissions on all procs in a db (drop/create scripts may have been run without re-assigning permissions)
ProcLike for matching 'starts with' pattern against proc names in DB,
revoke (optional - defaults to 0/True) specifies wheter to GRANT or REVOKE permissions
When doing bulk data changes it may be beneficial to disable indexes prior to starting the operation. Fortunately, SQL's rich metadata makes this very easy to automate in a robust fashion.