You can 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, Adaptive Server returns error message 10330.
