3.89.1. AuthBySelect Previous topic Parent topic Child topic Next topic

AuthBySelect is the SQL query used to retrieve AuthBy clause configuration parameters based on the user's realm. The clause is cached for reuse. You can use AuthBySelectParam to bind variables to the AuthBySelect query. %0 is replaced with SQL quoted realm when no AuthBySelectParams are configured.
The default value is:
AuthBySelect select HOST, PORT, AUTHDN, AUTHPASSWORD, BASEDN, USERNAMEATTR, \
     PASSWORDATTR, HOLDSERVERCONNECTION from RADSQLAUTHBY where TARGETNAME=%0
This is suitable for an AuthBy LDAP2 clause.