Question: Permission denied: Cannot CREATE PROCEDURE rroad_...
Answer: Foxhound has been unable to create one or more of the following procedures on the target database:
Foxhound will still work but performance of Foxhound itself may be affected, especially if there are a lot of connections to the target database.
One solution is to GRANT RESOURCE to the user id Foxhound uses to connect to the target database.
Another solution is to create the procedures yourself on the target database, with the Foxhound user id as the owner.
Foxhound Help - Introduction and Setup - Connecting to Target Databases.