sysencryptkeys

Changes to sysencryptkeys includes

• New types:

  • EK_KEYCOPY – 0x0010,

  • EK_KEYBASE – 0x0020

  • EK_RECOVERY – 0x0040

• New status bits:

  • EK_KEYRECOVERY(0x00000004) – keys encrypted for lost password protection.

  • EK_LOGINACCESS(0x00000008) – key encrypted for login access

  • EK_LOGINPASS (0x00000010) – key encrypted with login password

  • EK_USERPWD(0x00000100) – keys encrypted with user-encryption passwords

• Changes to the description for the uid column – user access or key recovery row. uid contains the user ID (uid) identifyinig the database user associated with current row.

  Previous versions of Adaptive Server did not use the uid column.