Modifies the maximum number of connections or the password expiration interval for a given user.
call sp_iqmodifylogin ( ‘{loginname | all overrides }’, ‘option’, value )
sp_iqmodifylogin ‘{loginname | all overrides }’, ‘option’, value
DBA authority required.
loginname Name of the account to be modified. If all
overrides is specified, the option and its value
apply to all users, except for the user DBA which cannot be set
to expire.
option Name of the option to be changed:
password_expiration Password
expiration interval in days, from 0 through 32767. 0 means the password
does not expire.
number_of_connections Maximum
number of concurrent database connections permitted for a given
user. 0 means unlimited connections.
sp_iqmodifylogin lets the DBA limit connections or set password expiration for a specified existing user, or for all other users. Changes take effect when Sybase IQ User Administration is enabled with sp_iqmodifyadmin, or immediately if Sybase IQ User Administration is already enabled.
The following errors may occur. Causes are listed after each error.
Permission denied: You do not have permission to change this password.
Cause: A user without DBA role tried to change another user’s password.
RAISERROR executed: "Userid <loginname not found."
Cause: The user tried to change the password of a user that does not exist.
The following stored procedure calls set password to expire in 365 days for all users except DBA.
sp_iqmodifylogin 'all overrides', 'password_expiration', 365
call sp_iqmodifylogin ('all overrides', 'password_expiration', 365)
