CREATE TABLE DBA.IQ_USER_LOGIN_INFO_TABLE userid VARCHAR(128) NOT NULL UNIQUE, login_locked CHAR(1) NOT NULL, number_connects INT NOT NULL, password_created TIMESTAMP DEFAULT CURRENT TIMESTAMP NOT NULL password_days INT NOT NULL) IN SYSTEM
IQ_USER_LOGIN_INFO_TABLE contains Sybase IQ User Administration values for each user.
login_locked Indicates whether the user is locked (Y) or allowed to connect (N).
number_connects Maximum number of concurrent database connections. Default is 0: IQ does not enforce a maximum number of connections.
password_days Number of days until a password expires. Default is 0: the password does not expire.
password_warning_days Number of days before a password expires that IQ sends a warning to the user.
