[SOL-360] Authenticate EXASolution user against LDAP server Created: 19.02.2016  Updated: 03.01.2020

Status: Published
Project: Solution Center
Component/s: EXAoperation, EXASolution
Affects Version/s: EXASolution 5.0.13
Fix Version/s: None

Type: How To
Reporter: Captain EXASOL Assignee: Captain EXASOL
Labels: None

Attachments: PNG File db.png     PNG File edit-db.png     PNG File ldap-entry-db.png    
Issue Links:
Related
Solution:

To authenticate EXASolution users against LDAP server(s), it is necessary to edit the corresponding database configuration in EXAoperation to the your LDAP server(s) URL.

The comma seperated LDAP servers list must be in the following format:

ldap[s]://my.ldapserver.example.com[:PORTNUMBER]

Please note, that a configuration changes requires a database restart for new settings being activated.

After the restart of the database users can be added in the database with the help of the following SQL statement:

CREATE USER user_2 IDENTIFIED AT LDAP
AS 'cn=user_2,dc=authorization,dc=exasol,dc=com';

Please refer to the EXASolution User Manual https://www.exasol.com/support/secure/attachment/38778/EXASolution_User_Manual-5.0.13-en.pdf for more details on syntax.

procedure
  • stop database
  • edit database configuration

  • add LDAP server
  • start database
Category 1: Cluster Administration - DB Instance Management
Category 2: Database Administration
Generated at Sun Aug 09 23:37:56 CEST 2020 using Jira 7.13.13#713013-sha1:4c0f5f5e3383570393fbbf3d2fd5de1eb4057c36.