The IQ User Administration facility helps you manage users and connections to a database. Using these system procedures, DBAs can add or drop users, limit connections for a user or a database, set password expirations, and lock out users.
When users log in, the sp_iq_process_login system procedure checks the IQ_USER_LOGIN_INFO_TABLE to ensure that the user is permitted to log in. It checks that the current number of connections for that user and for the database is not exceeded, that the user password is not expired, and that the user is not locked out. The database option LOGIN_PROCEDURE, which specifies a procedure to run when a user attempts to connect an IQ database, is set to sp_iq_process_login by default.
You can also create your own stored procedure that runs when users connect to an IQ database. This procedure can control initial conditions for users, such as option settings for users. It can also be used to disable new connections, based on criteria you define.
Set the LOGIN_PROCEDURE database option to the procedure you want to call when users log in. For details, see the Sybase IQ Reference Manual.
