Removing Decrypt Defaults

Multiple commands allow you to remove decrypt defaults.

Remove the decrypt default using any of these commands:

  • drop table

  • alter table .. modify .. drop col

  • alter table .. modify .. decrypt

  • alter table .. replace .. drop decrypt_default

For example, to remove the decrypt default attribute from the ssn column, enter:
alter table emp replace ssn drop decrypt_default

If you do not have the hr_role and select from the emp table after the table owner removed the decrypt default, SAP ASE returns error message 10330.

Parent topic: Default Values Returned Instead of Decrypted Data