UFN_SYSTEMROLE_GETMAPENTITYLIST

            CREATE FUNCTION dbo.UFN_SYSTEMROLE_GETMAPENTITYLIST(@SYSTEMROLEID uniqueidentifier)
            /*
            Returns a table of IDs for all of the Map Entities that have been assigned to the given SYSTEMROLEID
            */
            returns table
            as
            return 
            (
                select 
                    ME.ID, 
                    ME.MAPENTITYCATALOGID,
                    ME.GRANTORDENY
                from 
                    SYSTEMROLEPERM_MAPENTITY as ME
                where 
                    ME.SYSTEMROLEID=@SYSTEMROLEID
            )