USP_CMSOBJECTSECURITYEXCEPTION_ADDBYID

The save procedure used by the add dataform template "CMS Object Security Exception Add By ID".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@SourceObjectGUID	uniqueidentifier	IN
@TargetObjectGUID	uniqueidentifier	IN

Definition

Copy



                        CREATE PROCEDURE dbo.USP_CMSOBJECTSECURITYEXCEPTION_ADDBYID
                (
                @ID uniqueidentifier = null output,
                @SourceObjectGUID uniqueidentifier,
                @TargetObjectGUID uniqueidentifier
                )
                AS

                declare @CURRENTDATE datetime = getdate();
    declare @CHANGEAGENTID uniqueidentifier;
    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

    insert into CMSEVERYONESECURITYPRIVS(SECUREDOBJECTGUID, SECUREDOBJECTTYPEID, OBJECTTASKID, VALUE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
    select @TargetObjectGUID,
           SECUREDOBJECTTYPEID,
           OBJECTTASKID,
           VALUE,
           @CHANGEAGENTID,
           @CHANGEAGENTID,
           @CURRENTDATE,
           @CURRENTDATE
    from dbo.CMSEVERYONESECURITYPRIVS  
    where SECUREDOBJECTGUID = @SourceObjectGUID

    insert into dbo.CMSOBJETSECURITYEXCEPTION(SECUREDOBJECTGUID, EXCEPTIONOBJECTGUID, OBJECTTASKID, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
    select @TargetObjectGUID,
           EXCEPTIONOBJECTGUID,
           OBJECTTASKID,
           @CHANGEAGENTID,
           @CHANGEAGENTID,
           @CURRENTDATE,
           @CURRENTDATE
    from dbo.CMSOBJETSECURITYEXCEPTION
    where SECUREDOBJECTGUID = @SourceObjectGUID