USP_DATALIST_CMSOBJECTSECURITYEXCEPTION

Returns the exceptions for the specified exception object

Parameters

Parameter	Parameter Type	Mode	Description
@EXCEPTIONOBJECTGUID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



CREATE procedure dbo.USP_DATALIST_CMSOBJECTSECURITYEXCEPTION(@EXCEPTIONOBJECTGUID uniqueidentifier)
as
    set nocount on;

    select OSE.SECUREDOBJECTGUID,
           OT.ENUMID
    from dbo.CMSOBJETSECURITYEXCEPTION OSE
    inner join dbo.CMSOBJECTTASK OT
    on OT.ID = OSE.OBJECTTASKID
    where OSE.EXCEPTIONOBJECTGUID = @EXCEPTIONOBJECTGUID