USP_SECURITY_SYSTEMROLEFEATUREFOLDER_GET_MAPENTITIES

            CREATE procedure dbo.USP_SECURITY_SYSTEMROLEFEATUREFOLDER_GET_MAPENTITIES
            (
                @SYSTEMROLEID uniqueidentifier,
                @ONLYASSIGNED bit = 0
            )
            /* Used by the SecurityGetRoleFeaturePermTreeRequest web service */
            as
            set nocount on;

            IF @SYSTEMROLEID  IS NULL 
                begin
                RAISERROR('@SYSTEMROLEID is required',16,10);
                return 9;
                end;

            select
                [CATALOG].ID,
                [CATALOG].NAME,
                [CATALOG].SECURITYUIFOLDER,
                [PERM].GRANTORDENY,
                [CATALOG].DESCRIPTION,
                [PERM].ID as [PERMISSIONID],
                [CATALOG].MAPENTITYXML as SPECXML
            from dbo.MAPENTITYCATALOG as [CATALOG]
            left outer join
                (
                    select ID, GRANTORDENY, MAPENTITYCATALOGID 
                    from dbo.SYSTEMROLEPERM_MAPENTITY
                    where SYSTEMROLEID = @SYSTEMROLEID
                ) as [PERM] on [PERM].MAPENTITYCATALOGID = [CATALOG].ID
            where ([PERM].ID is not null) or (@ONLYASSIGNED = 0)
            order by [CATALOG].SECURITYUIFOLDER, [CATALOG].NAME