UFN_BATCHTEMPLATE_GETSYSTEMROLECUSTOMIZEPERMISSIONS

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

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@BATCHTEMPLATEID	uniqueidentifier	IN

Definition

Copy



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

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