How to store user messages?

Question

Database

Hello! When creating a corporate chat, the question arose about storing user messages in the database:
How to store user messages so that only a certain circle of people has access (and is it necessary at all)?
How to eliminate the possibility of leaks of correspondence?
Store encrypted?

Answer 1

You will not protect in any way if someone has access to the database. In addition, "encrypting irreversibly" is fraught with problems with law enforcement agencies (in any country) - you are obliged to provide correspondence at the request of the FSB, for example, Pasha's example and his Telegram, so think 10 times whether you need it or not, privacy games can cost you are very precious.