How to prevent decryption?

@cemproduction the better way to do this is to only give the developer access to a database that does not have production data in. Drush has sanitise commands to do this but my preferred way to do this is to not have databases going anywhere and have developers install the site from configuration and use the default content module to provide any content that's needed.

I have the same problem too. Unfortunately, there is no way to prevent access to the prod server for developers and engineers

Use pubkey_encrpyt to encrypt the data, create a second role, e.g. "dev" and give full access to that role. Since the encrypted data is not tied to "dev" role, he can do all the maintenance without access to the sensitive data.

Thanks for the solution. But this option is not suitable because with ssh access you can easily log in as any user with any role.

With SSH access to the server, I don't think there's much you can do to restrict access to the key; even with something like the Lockr module → , you can still poke around when you have command-line access.

If developers must have production access, perhaps a next-best solution is to log all ssh sessions and audit what the developer is doing?