Search Knowledge Base
KB #240035: SQL Error: Execute permission denied on object xp_n_*
|When attempting to access an encrypted column as a non-sysadmin user you may receive the following error:
Server: Msg 229, Level 14, ... EXECUTE permission denied on object 'xp_n_decrypt2', database 'master', owner 'dbo'.
|Each one of the following methods requires Sysadmin rights.Method 1 – Enable Cross Database Chaining
Method 2 – Grant Specific Permissions
use master create user appuser1 grant execute on xp_n_encrypt2 to appuser1 grant execute on xp_n_decrypt2 to appuser1 grant execute on xp_n_decrypt2m to appuser1