GET_USER_ROLES Function

59.78 GET_USER_ROLES Function

This function returns the DEVELOPER_ROLE field stored in the named user account record.

Syntax

APEX_UTIL.GET_USER_ROLES (
    p_username  IN  VARCHAR2 )
RETURN VARCHAR2;

Parameters

Parameter	Description
`p_username`	Identifies a user name in the account.

Example

The following example returns a colon-separated list of roles stored in the DEVELOPER_ROLE field for the user "FRANK."

DECLARE
    VAL VARCHAR2(4000);
BEGIN
    VAL := APEX_UTIL.GET_USER_ROLES(p_username=>'FRANK');
END;