ldap_query_password for MariaDB Xpand

Overview

In 23.09:

The password used with ldap_query_user when binding to an LDAP server to perform search operations. If this or ldap_query_user is empty, search operations are performed anonymously.

In 6.1, 6.0, 5.3:

Not present

See also: System Variables for MariaDB Xpand 23.09, in 6.1, in 6.0, and in 5.3

USAGE

The ldap_query_password system variable can be set by executing SET GLOBAL:

The global value of the ldap_query_password system variable can also be set dynamically at runtime by executing SET GLOBAL:

SET GLOBAL ldap_query_password = '<password>';

Using SET GLOBAL to set the value of a global variable in Xpand causes a change that will persist on restart.

DETAILS

The ldap_query_password system variable sets the password used with ldap_query_user when binding to an LDAP server to perform search operations. If this or ldap_query_user is empty, search operations are performed anonymously.

In order to set or read the contents of this variable, the SQL user requires the SYSTEM VARIABLE ADMIN permission.

SYNONYMS

SCHEMA

PARAMETERS

SKYSQL

PRIVILEGES

EXAMPLES

If ldap_query_user is also set, this password will be used when making queries to the LDAP server with the LDAP user DN specified by ldap_query_user:

SET GLOBAL ldap_query_password = 'secret';

ERROR HANDLING

FEATURE INTERACTION

RESPONSES

DIAGNOSIS

ISO 9075:2016

CHANGE HISTORY

Release Series

History

23.09

  • Added in MariaDB Xpand 23.09.1.

6.1

  • Not present.

6.0

  • Not present.

5.3

  • Not present.

EXTERNAL REFERENCES