Column Level Encryption - Mass Encryption Jobs

lkleijn
Giga Guru

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"

lkleijn_0-1717400003040.png

 

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.

 

1 REPLY 1

Paul Curwen
Giga Sage

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

 

 

***If Correct/Helpful please take time mark as Correct/Helpful. It is much appreciated.***

Regards

Paul