4

Database Activity Monitoring

SL-10

Continuous, near real-time visibility into every query against a personal-data table — who ran it, from where, with what tool, and which classified columns it touched. Tamper-resistant, with administrative segregation so nobody can both configure monitoring and erase its output.

DischargesS.8(4)R.6S.9
Databases monitored
15
View
Not fully monitoring
3
Classified columns
1.61 K
Children's data columns
359
Open detections
24
Critical
6
Query volume and flags

56.6 L queries observed today across 12 monitored instances.

Database engines

Coverage across the estate.

  • PostgreSQL5
  • Oracle3
  • Microsoft SQL Server2
  • MySQL2
  • Snowflake1
  • Databricks1
  • MongoDB1
Detection types

Mass reads and export anomalies dominate, which is what you would expect if the control is working.

All detections
Highest-risk databases

Ranked by classified column count and open alerts.

All databases
  • Criticalfamilyid-prod-01Oracle38 child cols214columns
  • Criticalfamilyid-dr-oracleOracle38 child cols214columns
  • Criticalanalytics-lakehouseDatabricks52 child cols203columns
  • Highbeneficiary-warehouseSnowflake41 child cols187columns
  • Criticalhealthcard-mysqlMySQL34 child cols112columns
  • Highportal-prod-pgPostgreSQL12 child cols96columns
Active policies

Granularity down to the column, with sensitivity-based logging fidelity — full capture on personal-data tables, standard elsewhere.

Configure
  • Mass read on citizen identifier tablestablecitizen.beneficiary, citizen.householdBaseline-driventerminate session6Active
  • Any access to children's data columnscolumnwelfare.enrolment.student_name, student_dob, guardian_contactBreak-glass activealert41Active
  • Privilege change on classified objectsinstanceAll production instancesalert14Active
  • Service account outside its windowusersvc_* accountsBaseline-drivenblock user3Active
  • Export to file from any classified tableschemacitizen.*, health.*, welfare.*quarantine9Active
  • Attempt to disable auditinginstanceAll instancesalert2Active

Related