SYSLANGAUTH

The syslangauth system catalog table contains the authorization information about computer languages that are used to write user-defined routines (UDRs).
Table 1. SYSLANGAUTH table column descriptions

Column Type Explanation
grantor VARCHAR(32) Name of the grantor of the language authorization
grantee VARCHAR(32) Name of the grantee of the language authorization
langid INTEGER Identifying code of language in sysroutinelangs table
langauth CHAR(1) The language authorization:
  • u = Usage privilege granted
  • U = Usage privilege granted WITH GRANT OPTION

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