USP_DATALIST_CMSEVERYONESECURITYPRIVS_EXCEPTIONS

CREATE procedure dbo.USP_DATALIST_CMSEVERYONESECURITYPRIVS_EXCEPTIONS
as
    set nocount on;

    select ESP.SECUREDOBJECTGUID,
           ESP.SECUREDOBJECTTYPEID,
           OT.ENUMID,
           ESP.VALUE
    from dbo.CMSEVERYONESECURITYPRIVS ESP
    inner join dbo.CMSOBJECTTYPEOBJECTTASK OTOT
    on OTOT.OBJECTTYPEID = ESP.SECUREDOBJECTTYPEID and OTOT.OBJECTTASKID = ESP.OBJECTTASKID
    inner join dbo.CMSOBJECTTASK OT
    on OT.ID = ESP.OBJECTTASKID
    where OTOT.DEFAULTVALUE != ESP.VALUE