Contains one or more rows for each stored procedure or User Defined Function which describes the user privileges to access these objects.

The following table provides details of the SYSPROCAUTH table.

Table 1. SYSPROCAUTH system table
Column name Column data type Column size
Alt VARCHAR 1
AuthMask BIGINT 8
Exe VARCHAR 1
grantor VARCHAR 32
grantee VARCHAR 32
grantor-domainId INTEGER 8
grantee-domainId INTEGER 8
procowner VARCHAR 32
procname VARCHAR 32
SnapShotVer INTEGER 4