SYSPROCAUTH

The sysprocauth system catalog table describes the privileges granted on a procedure or function. It contains one row for each set of privileges that is granted. The sysprocauth table has the following columns.
Table 1. SYSPROCAUTH table column descriptions
Column Type Explanation
grantor VARCHAR(32) Name of grantor of privileges to access the routine
grantee VARCHAR(32) Name of grantee of privileges to access the routine
procid INTEGER Unique identifying code of the routine
procauth CHAR(1) Type of privilege granted on the routine:
  • e = Execute privilege on routine
  • E = Execute privilege WITH GRANT OPTION

A composite index on the procid, grantor, and grantee columns allows only unique values. A composite index on the procid and grantee columns allows duplicate values.