Update the SECURITY.md

[tishun]

Feature Request

Is your feature request related to a problem? Please describe

We need to adapt the SECURITY.md to match the ones we have in other OSS projects.

Describe the solution you'd like

See Redis server security notes.
See node-redis security notes.

Describe alternatives you've considered

N/A

Teachability, Documentation, Adoption, Migration Strategy

N/A