APPL_AUTHNAMES

The syntax description for the user defined function table is:

>>-APPL_AUTHNAMES(--+----------+--)----------------------------><
                    '-adjuncts-'

>>-RETURNS TABLE(--+----------+--)-----------------------------><
                   +-authname-+
                   '-namekind-'

The APPL_AUTHNAMES function returns the DB2 Authorization IDs for the current application process. A row is returned for each authorization name. The schema name is Q.

adjuncts VARCHAR(255)

A string of authorization names. Specify each authorization name as an identifier or a delimited identifier. Separate each authorization name by one or more blanks:

'SALES "DEPT A1" PAYROLL'

These three names would be added to the output of the function should they represent distinct values not already defined as authorization IDs for the current process.

The result of the function is a DB2 table with the following columns:

• authname CHARACTER (8)

  The name for an authorization ID of the current process.

• namekind CHARACTER(1)

  A classification code for the name value in AUTHNAME:

  • 1 Primary authorization ID or user name
  • 2 Secondary authorization ID or group name
  • 3 Current authorization ID

    This applies only when the CURRENT SQLID is neither the primary ID nor a secondary ID of the current process.

  • 9 Adjunct name value

    This applies only when the ADJUNCT parameter is used and the identifiers it specifies are not authorization IDs of the current process.