I'm looking for a way to protect the identity of people in my SQL database. The database has rows containing an unique hash that represents a person and personal data about this person. The idea is that certain personal/medical data is hashed so anyone can add/edit/delete columns and anyone can request columns but can never request the unique hashes.
Representation database:
Joe+1994 --> q4y23z
|Hash| |Age| |Height| |Smoker| --------------------------------- q4y23z 21 200cm 0 r8h32l 21 100cm 1 9itj5b 21 100cm 1
This all works fine but the database is very small at this moment. If someone knows that I am represented in this database and knows that I for instance am a non-smoker and am 2m tall then this person will discover my identity and other personal data. Is there any known technique to limit the access to certain columns until the amount of rows is large enough to provide anonymity?
Sincerely,
Joe