Column Level Encryption - Mass Encryption Jobs

[lkleijn]

I've been setting up Column Level Encryption (CLE) on a customer's environment.

So far it's been going great but recently something changed and I can't get mass encryption Jobs to run.

I get the following error on any kind of job : "The current user lacks sufficient privileges to access required encryption keys"

I have no idea what changed because before last week I could run those jobs. Also colleagues can still run those jobs without issues.

Here's what I've tried :

• Removing then giving back to myself the sn_kmf.cryptographic_manager role
• Rotating/getting a new encryption key
• Creating a new user with the security admin + sn_kmf.cryptographic_manager roles and trying with this new user.

[Paul Curwen]

Make sure you have elevated to 'security_admin' first, you need to manually elevate to get that role then run the mass encryption job.