Programming Guides › Programming Guide for Perl › CLI Policy Management Methods › ODBC Query Scheme Methods › QueryAuthenticateUser Method—Sets or Retrieves a Query that Fetches a User's Password

QueryAuthenticateUser Method—Sets or Retrieves a Query that Fetches a User's Password

The QueryAuthenticateUser method sets or retrieves a query that fetches a user's password.

Syntax

The QueryAuthenticateUser method has the following format:

Netegrity::PolicyMgtODBCQueryScheme‑>QueryAuthenticateUser([queryAuthUser])

Parameters

The QueryAuthenticateUser method accepts the following parameter:

queryAuthUser (string)

(Optional) Specifies the query that fetches a user's password.

Return Value

The QueryAuthenticateUser method returns one of the following values:

• The new or existing query
• undef if the call is unsuccessful

Remarks

Sample query (based on the SiteMinder sample database schema SmSampleUsers). The %s expression is a placeholder for the user's name parameter to be supplied by SiteMinder when the query is executed:

select Name from SmUser where Name = '%s' and Password = '%s'

If you are configuring a query scheme for an Oracle database and you are using Oracle's encrypted password feature, replace the entire query string with the word connect. Using the word connect for this query indicates to SiteMinder that a user's name and password should be evaluated by the Oracle encrypted password feature.