FUNCTION_USAGE view
The FUNCTION_USAGE view contains function usage configuration details.
The values returned for the columns in the view are closely related to the values returned by the Display Function Usage (DSPFCNUSG) CL command.
Authorization: The caller must have *SECADM special authority.
The following table describes the columns in the view. The system name is FCN_USAGE. The schema is QSYS2.
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.
|
USER_TYPE | USER_TYPE | VARCHAR(5) | Type of user profile.
|
Example
Determine what function usage has been granted or revoked.
SELECT * FROM QSYS2.FUNCTION_USAGE ORDER BY FUNCTION_ID, USER_NAME