TR_SYSTEMROLETASK_GRANT_IMPLIED_FEATUREPERMS (Trigger)

        

CREATE TRIGGER dbo.TR_SYSTEMROLETASK_GRANT_IMPLIED_FEATUREPERMS ON dbo.SYSTEMROLETASK 
AFTER INSERT NOT FOR REPLICATION
AS 

set nocount on;

declare @TASKID uniqueidentifier;
declare @ROLEID uniqueidentifier;
declare @CHANGEDBYID uniqueidentifier;
declare TASKCURSOR cursor local fast_forward for
    select TASKID,SYSTEMROLEID,CHANGEDBYID
    from
    inserted;
        
open TASKCURSOR;
fetch next from TASKCURSOR into @TASKID, @ROLEID,@CHANGEDBYID;
    
while @@fetch_status = 0 begin

    exec dbo.USP_TASK_GRANT_IMPLIED_FEATUREPERMS @TASKID,@ROLEID,@CHANGEDBYID;
    
    fetch next from TASKCURSOR into @TASKID, @ROLEID,@CHANGEDBYID;

end

close TASKCURSOR;
deallocate TASKCURSOR;