Solution 1:
- Go the LDAP maintenance window (Maintenance | Security Settings | Ldap connect).
- Select the server (there could be more than one) and then click "Assign to Users" button.
- On the popup screen a list of all active users is displayed. It can filter using the drop down list to show just users who are Unassigned.
- Then there is a select all button and a select none button and/or can do multiple row selects and then click Update User DN button.
Solution 2:
1. Examine the output of the statement from STATUSER table for the user that has the problem.
SELECT * FROM STATUSER
It should have the columns values as below:
enable_ldap='Y', ldap_cd='<LDAP_NAME>' and reset_password='N'
2. If the values are different then update by the following statement:
SQL> update statuser set enable_ldap='Y' where userid='<NEW_USER>';
SQL> update statuser set ldap_cd='LDAP_NAME' where userid='<NEW_USER>';
SQL> update statuser set reset_password='N' where userid='<NEW_USER>';
SQL> commit;
3. Make sure to enable ldap for the particular user you are testing and verify the checkbox 'enable LDAP' is turned on in
Maintenance | General | System maintenance | Other options tab
