I am pretty unknown to encryption strategies in production environments. So my concern is to find a solution how to strongly encrypt data, but make it available to multiple users with different keys.
More specific, it is a patient - medical stuff scenario, where patient data is stored encrypted on a server and may only be accessed, hence decrypted, by the patients key or his/hers doctors key or any other authorized entity.
Which concepts are there available? And which are used in production systems, i.e. implemented for databases (like mysql ) or file storage, etc. Which libraries are available (java, c/c++), or which similar concepts are known.
I hope my question was not to unspecific, if yes please ask.