USP_DATALIST_CMSOBJECTSECURITYEXCEPTIONFOROBJECT

                    CREATE procedure dbo.USP_DATALIST_CMSOBJECTSECURITYEXCEPTIONFOROBJECT(@SECUREDOBJECTGUID uniqueidentifier)
as
    set nocount on;

    select OSE.EXCEPTIONOBJECTGUID,
          OSE.OBJECTTASKID,
            CASE WHEN CR.NAME IS NULL THEN CU.FirstName + ' ' + CU.LastName + ' (' + CU.UserName + ')' ELSE CR.NAME END as NAME,
            OT.ENUMID,
            CR.ID as ROLEID, 
            CU.ID as USERID
    from dbo.CMSOBJETSECURITYEXCEPTION OSE
    inner join dbo.CMSOBJECTTASK OT on OSE.OBJECTTASKID = OT.ID
    left outer join dbo.ClientRoles CR
    on CR.Guid = OSE.EXCEPTIONOBJECTGUID
    left outer join dbo.ClientUsers CU
    on CU.Guid = OSE.EXCEPTIONOBJECTGUID
    where OSE.SECUREDOBJECTGUID = @SECUREDOBJECTGUID and (CU.Deleted IS NULL or CU.Deleted = 0)