Stored Routine Manager allows you to view and modify the basic parameters of all
stored procedures and functions within the diagram.
To open Stored Routine Manager use the Diagram | Stored Routine Manager menu
item.
The main part of the dialog window is the stored routines grid. The grid rows stand for the stored
procedures and functions, and the grid columns stand for their parameters.
These parameters can be changed by using Stored Routine
Editor for each routine one by one, but with the manager you can do it much more quickly.
The grid allows you to modify the following properties:
Name - the name of the routine;
Security type - this option can be used to specify whether the routine should be
executed using the permissions of the user who creates the routine or the user who invokes it. The
default value is DEFINER. The creator or invoker must have permission to access the database with
which the routine is associated;