Security Operations
HeliosDB Security Operations
Use this guide for operational security checks, incident handling, access review, and audit readiness.
Access Review
Review privileged access regularly:
- Database superusers and administrative roles.
- Service accounts and automation tokens.
- SSH, Kubernetes, and cloud IAM access.
- Break-glass credentials and rotation records.
SELECT rolname, rolsuper, rolcreaterole, rolcreatedbFROM pg_rolesORDER BY rolname;Secret Rotation
Rotate credentials when:
- A user changes role or leaves the team.
- A secret is suspected to be exposed.
- A dependency or deployment pipeline changes.
- The regular rotation window arrives.
Rotation steps:
- Create the replacement secret.
- Deploy to dependent services.
- Validate authentication.
- Revoke the old secret.
- Record the rotation.
Audit Checks
Check audit trails for:
- Privilege changes.
- Failed authentication spikes.
- DDL changes.
- Access to sensitive tables.
- Disabled alerts or monitoring gaps.
Security Incident Response
For suspected unauthorized access:
- Treat as a high-severity incident.
- Preserve logs and audit records.
- Disable affected credentials.
- Identify affected data and systems.
- Rotate secrets after containment.
- Document impact and follow-up actions.
Hardening Checklist
- TLS is enabled for client and replication traffic.
- Administrative access is least privilege.
- Audit logging is enabled and retained.
- Backups are encrypted.
- Public endpoints are intentionally exposed.
- Alerting covers authentication failures and privilege changes.