Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » MobiLink - Client Administration » MobiLink Users » Custom user authentication

Java and .NET user authentication Next Page

SQL user authentication

A typical authenticate_user SQL script is a call to a stored procedure that uses the parameters authentication_status, ml_username, user_password, and user_new_password. The order of the parameters in the call must match this. For example, in a SQL Anywhere consolidated database, the format is:

call my_authentication( ?, ?, ?, ? )

where the first argument is the authentication code, and so on. The authentication code is an integer type, and the other parameters are VARCHAR(128).

In Transact-SQL, the format is:

execute ? = my_authentication( ?, ?, ? )

where the authentication code is the parameter on the left hand side.

See authenticate_user connection event.