CREATE PROCEDURE [dbo].[GetModelItemInfo]
@Path nvarchar (425)
AS
SELECT
    MIP.[ModelItemID], SD.[NtSecDescPrimary], SD.[XmlDescription]
FROM
    [Catalog] AS C
    INNER JOIN [ModelItemPolicy] AS MIP ON C.[ItemID] = MIP.[CatalogItemID]
    LEFT OUTER JOIN [SecData] AS SD ON MIP.[PolicyID] = SD.[PolicyID]
WHERE
    C.[Path] = @Path
    

GO
GRANT EXECUTE ON  [dbo].[GetModelItemInfo] TO [RSExecRole]
GO