UFN_BATCHTEMPLATE_GETPROCESSORPERMISSIONS

This SQL function returns all of the system role permissions for processors of a given batch template.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@BATCHTEMPLATEID	uniqueidentifier	IN

Definition

Copy



create function UFN_BATCHTEMPLATE_GETPROCESSORPERMISSIONS
(
    @BATCHTEMPLATEID as uniqueidentifier
)
returns table
as
return
(
    select
        SYSTEMROLEPERM_BATCHTEMPLATEPROCESSOR.ID,
        SYSTEMROLE.ID as SYSTEMROLEID,
        SYSTEMROLE.NAME,
        coalesce(SYSTEMROLEPERM_BATCHTEMPLATEPROCESSOR.GRANTORDENY, 2) as GRANTORDENY

    from
        dbo.SYSTEMROLE
        left outer join dbo.SYSTEMROLEPERM_BATCHTEMPLATEPROCESSOR
            on SYSTEMROLE.ID = SYSTEMROLEPERM_BATCHTEMPLATEPROCESSOR.SYSTEMROLEID
            and SYSTEMROLEPERM_BATCHTEMPLATEPROCESSOR.BATCHTEMPLATEID = @BATCHTEMPLATEID                
)