FUNCTION_USAGE view

The FUNCTION_USAGE view contains function usage configuration details.

Authorization: Only callers with *SECADM user special authority can examine the function usage configuration details returned with this view. Callers without *SECADM authority who attempt to reference this view will get SQLCODE -443.

The following table describes the columns in the view. The system name is FCN_USAGE. The schema is QSYS2.

Table 1. FUNCTION_USAGE view
Column Name System Column Name Data Type Description
FUNCTION_ID FCNID VARCHAR(30) The ID of the function.
USER_NAME USER_NAME VARCHAR(10) The name of the user profile that has a usage setting for this function
USAGE USAGE VARCHAR(7) Usage setting.
ALLOWED
The user profile is allowed to use the function.
DENIED
The user profile is not allowed to use the function.
USER_TYPE USER_TYPE VARCHAR(5) Type of user profile.
USER
The user profile is a user.
GROUP
The user profile is a group.

Example

Determine what function usage has been granted or revoked.

 SELECT * FROM QSYS2.FUNCTION_USAGE ORDER BY FUNCTION_ID, USER_NAME