UFN_CODETABLE_GETCODETABLEENTRYPERMISSIONS

This function returns all securable code table entries and their permissions for a given system role.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@SYSTEMROLEID	uniqueidentifier	IN
@CODETABLECATALOGID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_CODETABLE_GETCODETABLEENTRYPERMISSIONS
            (
                @SYSTEMROLEID uniqueidentifier,
                @CODETABLECATALOGID uniqueidentifier
            )
            returns table
            as
            return
                select
                    ID,
                    CODETABLECATALOGID,
                    CODETABLEENTRYID,
                    ISDENIED
                from
                    dbo.SYSTEMROLEPERM_CODETABLEENTRY
                where
                    SYSTEMROLEID = @SYSTEMROLEID
                and
                    CODETABLECATALOGID = @CODETABLECATALOGID