40.5 MEMBER_OF Function
This function returns an array of groups the user name designated by p_username
(with password if required) belongs to, using the provided auth base, host, and port.
Syntax
APEX_LDAP.MEMBER_OF (
p_username IN VARCHAR2 DEFAULT NULL,
p_pass IN VARCHAR2 DEFAULT NULL,
p_auth_base IN VARCHAR2,
p_host IN VARCHAR2,
p_port IN VARCHAR2 DEFAULT 389,
p_use_ssl IN VARCHAR2 DEFAULT 'N',
p_credential_static_id IN VARCHAR2 DEFAULT NULL );
RETURN apex_application_global.vc_arr2;
Parameters
Table 40-5 MEMBER_OF Parameters
Parameter | Description |
---|---|
p_username |
Login name of the user. |
p_pass |
Password for p_username .
|
p_auth_base |
LDAP search base, for example, dc=users,dc=my,dc=org .
|
p_host |
LDAP server host name. |
p_port |
LDAP server port number. |
p_use_ssl |
(Default) Set to Set to Set to |
p_credential_static_id |
The credential static ID (can be NULL for anonymous or username/pass binds). If it is not NULL and the credential could not be found, then raises the error |
Example
The following example demonstrates how to use the APEX_LDAP.MEMBER_OF
function to retrieve all the groups designated by the specified username.
DECLARE
L_MEMBERSHIP apex_application_global.vc_arr2;
BEGIN
L_MEMBERSHIP := APEX_LDAP.MEMBER_OF(
p_username => 'firstname.lastname',
p_pass => 'abcdef',
p_auth_base => 'cn=user,l=amer,dc=example,dc=com',
p_host => 'our_ldap_sever.example.com',
p_port => '636'
p_use_ssl => 'A');
FOR i IN L_MEMBERSHIP.FIRST..L_MEMBERSHIP.LAST LOOP
htp.p('Member of: '||L_MEMBERSHIP(i));
END LOOP;
END;
Parent topic: APEX_LDAP