QUSRBRM.FUNCTIONAL_AUTHORITY_INFO View

The QUSRBRM.FUNCTIONAL_AUTHORITY_INFO view shows functional authority information for BRMS functions.

Authorization:

The authorization ID of the statement must include the following privileges:

Result Table

The following table describes the columns in the view. The system name is FUNC_AUTH. The schema is QUSRBRM.

Column Name	System Column Name	Data Type	Description
USER_NAME	USER_NAME	VARCHAR(10)	The user profile associated with the functional authority entry.
BRMS_USAGE	BRMS_USAGE	VARCHAR(9) Nullable	The BRMS usage assigned to the user via SETUSRBRM. The possible values are: ADMIN - The user is a BRMS administrator. OPERATOR - The user is a BRMS operator. Contains the null value when the user has not been assigned as an ADMIN or OPERATOR via SETUSRBRM.
BRMS_FUNCTION_ID	FCNID	VARCHAR(30)	The BRMS functional usage ID For details on the BRMS supplied function IDs reference the IBM-supplied function IDs Table 3
FUNCTION_USAGE	USAGE	VARCHAR(7)	The usage to the specific BRMS functional usage ID for the specified user. The possible values are: ALLOWED - The user is allowed access to items protected by this functional authority entry. DENIED - The user is denied access to items protected by this functional authority entry.

Examples:

Example 1: Display all BRMS Functional Usage (sorted by USER_NAME & BRMS_FUNCTION_ID)

SELECT * FROM QUSRBRM.FUNCTIONAL_AUTHORITY_INFO ORDER BY USER_NAME, BRMS_FUNCTION_ID

Example output:

SELECT * FROM QUSRBRM.FUNCTIONAL_AUTHORITY_INFO WHERE USER_NAME='BRMADM1' ORDER BY BRMS_FUNCTION_ID

Example output:

SELECT * FROM QUSRBRM.FUNCTIONAL_AUTHORITY_INFO WHERE USER_NAME LIKE 'BRMADM%'

Example output:

SELECT * FROM QUSRBRM.FUNCTIONAL_AUTHORITY_INFO WHERE BRMS_FUNCTION_ID LIKE 'QIBM_Q1A_BKU_CTLG_%'

Example output:

SELECT USER_NAME, BRMS_USAGE FROM QUSRBRM.FUNCTIONAL_AUTHORITY_INFO GROUP BY USER_NAME, BRMS_USAGE ORDER BY USER_NAME, BRMS_USAGE

Example output: