Home | Previous Page | Next Page   System Catalog Tables >

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.

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.

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]