CREATE PROCEDURE [dbo].[GetPolicyRoots]
AS
SELECT
    [Path],
    [Type]
FROM
    [Catalog]
WHERE
    [PolicyRoot] = 1

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