sp_iq_process_login procedure

Function

Checks that a user is permitted to connect.

Syntax

sp_iq_process_login

Permissions

None.

See also

“sp_iqmodifyadmin procedure”

“LOGIN_PROCEDURE option”

Description

When a user logs on, IQ calls the stored procedure specified by the database option LOGIN_PROCEDURE. The default setting of the LOGIN_PROCEDURE option is DBA.sp_iq_process_login.

When Sybase IQ User Administration is enabled, sp_iq_process_login checks that the user is not locked out, that the maximum number of connections for the user and database is not exceeded, and that the user’s password has not expired, and then either allows user login to proceed or sends an error message. When Sybase IQ User Administration is disabled, user login proceeds without any checking.

When user login is allowed to proceed, sp_iq_process_login calls the sp_login_environment system procedure for additional processing.

This procedure is called automatically. You do not need to call it directly, unless you are creating your own login procedures. If you set LOGIN_PROCEDURE to call a different procedure, no login checking occurs.