48.75 GET_USER_ROLES Function
This function returns the DEVELOPER_ROLE
field stored in the named user account record. Please note that currently this parameter is named inconsistently between the CREATE_USER
, EDIT_USER
and FETCH_USER
APIs, although they all relate to the DEVELOPER_ROLE
field. CREATE_USER
uses p_developer_privs
, EDIT_USER
uses p_developer_roles
and FETCH_USER
uses p_developer_role
.
Syntax
APEX_UTIL.GET_USER_ROLES(
p_username IN VARCHAR2)
RETURN VARCHAR2;
Parameters
Table 48-64 GET_USER_ROLES Parameters
Parameter | Description |
---|---|
|
Identifies a user name in the account. |
Example
The following example shows how to use the GET_USER_ROLES
function to return 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;
Parent topic: APEX_UTIL