To see or process decrypted data, users must have certain permissions.
select and decrypt permissions on the column used in the target list and in where, having, order by, group by, and other such clauses
A password used to encrypt the key if you use the passwd password_phrase clause with the create or alter encryption key commands.
Configuring SAP ASE for restricted decrypt permission restricts implicit decrypt permissions. You must explicitly grant table owners decrypt permission to enable them to select from an encrypted column on tables that they own. execute permission on a stored procedure or select permission on a view does not implicitly grant users decrypt permission on the underlying encrypted data through an ownership chain. The user must also have explicit decrypt permission on the base table.