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

Table: GET_USER_ROLES Parameters describes the parameters available in GET_USER_ROLES function.

GET_USER_ROLES Parameters

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

Example

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