UFN_CODETABLE_GETSYSTEMROLEPERMISSIONS

This SQL function returns all of the system role permissions for a given code table.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@CODETABLECATALOGID	uniqueidentifier	IN

Definition

Copy



            create function UFN_CODETABLE_GETSYSTEMROLEPERMISSIONS 
            (
                @CODETABLECATALOGID as uniqueidentifier
            )
            returns table
            as
            return
            (
                select
                    SYSTEMROLEPERM_CODETABLE.ID,
                    SYSTEMROLE.ID as SYSTEMROLEID,
                    SYSTEMROLE.NAME,
                    coalesce(SYSTEMROLEPERM_CODETABLE.ADDPERMISSIONCODE, 0) as ADDPERMISSIONCODE,
                    coalesce(SYSTEMROLEPERM_CODETABLE.UPDATEPERMISSIONCODE, 0) as UPDATEPERMISSIONCODE,
                    coalesce(SYSTEMROLEPERM_CODETABLE.DELETEPERMISSIONCODE, 0) as DELETEPERMISSIONCODE
                from
                    dbo.SYSTEMROLE
                    left outer join dbo.SYSTEMROLEPERM_CODETABLE
                        on SYSTEMROLE.ID = SYSTEMROLEPERM_CODETABLE.SYSTEMROLEID
                        and SYSTEMROLEPERM_CODETABLE.CODETABLECATALOGID = @CODETABLECATALOGID
                where @CODETABLECATALOGID in (select ID from CODETABLECATALOG)
            )