Automated operator account creation and role assignment script

[#1]

Summary

This guide provides an explanation of a stored procedure that can be used to automate operator account creation

Synopsis

Before carrying out the following steps, please ensure you take a full back of your database.

SP GroupExAddGroupMembership can be used for adding an operator to a role.

Example Usage

-- Add given group member that is not in a group of the given type to a group of the given type
? i.e. assumes that group member is not already in a group of this type
exec dbo.GroupExAddGroupMembership @GroupID=7,@TargetID=2,@TargetType=N'ComplianceOperator',@GroupTypeID=5