40.6 MEMBER_OF2 Function
This function returns a VARCHAR2
colon delimited list 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_OF2 (
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 VARCHAR2;
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_OF2
function to retreive all the groups designated by the specified username.
DECLARE
L_VAL varchar2(4000);
BEGIN
L_VAL := APEX_LDAP.MEMBER_OF2(
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');
htp.p('Is Member of:'||L_VAL);
END;
Parent topic: APEX_LDAP