System and user defined roles that are active when a threshold procedure is created are preserved in systhresholds.
In Adaptive Server 15.7 ESD#3 and earlier, sp_addthreshold preserves the system roles that are active when the threshold procedure is created. However, only directly granted system roles that have not been revoked since the threshold was created are activated when the threshold fires. Indirectly granted system roles and user-defined roles are not activated.
This restriction has been relaxed and all system and user defined roles active when the threshold procedure is created are preserved in systhresholds. All system and user defined roles that the user had at time of creating the threshold and that have not been revoked will be activated when the threshold fires.