USER_PROCEDURES

Provides information about stored procedures and external procedures.

Provides information about stored procedures and external procedures. Users can only view procedures that they can execute.

Column Name Data Type Description
PROCEDURE_NAME VARCHAR The name of the procedure.
OWNER VARCHAR The owner (definer) of the procedure.
LANGUAGE VARCHAR

The language in which the procedure is defined.

For external procedures, this will be EXTERNAL.

For stored procedures, this will be one of the supported languages.

SECURITY VARCHAR

The privileges to use when executing the procedure, one of the following:

  • DEFINER: Executes the procedure with the privileges of the owner (definer) of the procedure.

  • INVOKER: Executes the procedure with the privileges of the invoker.

For details, see Executing stored procedures.

PROCEDURE_ARGUMENTS VARCHAR The arguments of the procedure.
SCHEMA_NAME VARCHAR The schema in which the procedure was defined.

Privileges

Non-superusers can only view information on a procedure if they have:

  • USAGE privileges on the procedure's schema.

  • Ownership or EXECUTE privileges on the procedure.

Examples

=> SELECT * FROM user_procedures;
   procedure_name   |  owner  | language | security |                               procedure_arguments                                 | schema_name
--------------------+---------+----------+----------+-----------------------------------------------------------------------------------+-------------
 accurate_auc       | dbadmin | PL/vSQL  | INVOKER  | relation varchar, observation_col varchar, probability_col varchar, epsilon float | public
 conditionalTable   | dbadmin | PL/vSQL  | INVOKER  | b boolean                                                                         | public
 update_salary      | dbadmin | PL/vSQL  | INVOKER  | x int, y varchar                                                                  | public
(3 rows)