sysattributes

sysattributes includes these changes:

• Adds two classes:

  • Class 31 allow password downgrade – when set to 1, allow password downgrade enables special handling of login passwords for compatibility with Adaptive Server release 15.0 and earlier.

  • Class 32 enable last login updates – when set to 1, enable last login updates enables system tables to store the date of the last login.

• sysattributes includes information about default decrypt. These are the changes to the columns:

  • attribute – specifies a default decrypt on an encrypted column with a value of 1 (DECRYPT-DEFAULT_ID) for objects with a type of EC and a class of 25.

  • object – includes the decypt default ID.

  • object_info_1 – includes the table ID for a table whose encrypted column defines the decrypt default.

  • object_info2 – specifies the colid of the encrypted column that includes the decrypt default.