Access Encrypted Data

SAP ASE automatically performs encryption and decryption when you process data in encrypted columns. SAP ASE encrypts data when you update or insert data into an encrypted column, and decrypts data when you select it or use it in a where clause.

• Encrypted Columns Process
  When you issue a select, insert, update, or delete command against an encrypted column, SAP ASE automatically encrypts or decrypts the data using the encryption key associated with the encrypted column.
• Permissions for Decryption
  To see or process decrypted data, users must have certain permissions.
• Drop Encryption
  If you are a table owner, you can use alter table with the decrypt option to drop encryption on a column.