USP_DATALIST_CMSEVERYONESECURITYPRIVS

The exceptions defined for the everyone role for all CMS objects.

Parameters

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

Definition

Copy



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

select EP.SECUREDOBJECTGUID,
           EP.SECUREDOBJECTTYPEID,
           EP.OBJECTTASKID,
           EP.VALUE,
           OT.ENUMID,
           OT.TASKNAME
    from dbo.CMSEVERYONESECURITYPRIVS EP
    inner join dbo.CMSOBJECTTASK OT on EP.OBJECTTASKID = OT.ID
    where SECUREDOBJECTGUID = @SECUREDOBJECTGUID