Changed System Tables

sysattributes

Stores information for the configuration parameters that set or change the password expiration interval, maximum failed login attempts, and the minimum password length.

sysconfigures

Stores the server-wide values set with the configuration parameters minimum password length and maximum failed logins for logins and roles.

syslogins

The new column, logincount, indicates the number of failed logins. A successful login automatically resets the number of failed logins to 0. The datatype of this column is int.

syservroles

The following columns have been added:

• pwdate – records the date and time when the password of a role was last changed. The datatype of this column is datetime.

• status – indicates the status of the role. The datatype of this column is smallint. The status is shown as a numeric value that corresponds to the combination of expiration and lock status for the role. The values are:

  • 0 – role is not expired or locked

  • 2 – role is not expired but is locked

  • 4 – role is expired but is not locked

  • 6 – role is expired and locked

sysusers

In previous releases, the sysusers system table in each database had a unique clustered index on suid. However, in Adaptive Server 12.0 the uniqueness of sysusers.suid does not exist, so the clustered index has been dropped.