FUNCTION_USAGE view
The FUNCTION_USAGE view contains function usage configuration details.
Only users with *SECADM user special authority can examine the function usage configuration details returned with this view. Users without *SECADM authority who attempt to reference this view will get SQLCODE -443.
The following table describes the columns in the view. 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