Resolution and encryption of SQl 2008 server

Question

I made columns in some tables encrypted in SQL Server 2008. Now that I own db, I have access to encrypt and decode data using a symmetric key and certificate. But some other users only have rights to the data and DataLister data, and when they execute any SP that refers to the logic that uses the key and the certificate "The user does not have the right to execute the certificate." What rights / exact permissions should I grant them only to solve this problem.

Answer 1

Thanks to Dynamo Solution GRANT CONTROL ON CERTIFICATE :: server_name To username

https://serverfault.com/questions/122851/sql-server-2008-permission-and-encryption