Personal data found, hidden and controlled by role

Each question was asked once as every role, so the answers sit side by side without switching roles. All three cover claims reported from October 2025 to September 2026. Your role's column is highlighted.

• A refused question is stopped by a fixed access rule before its query runs, so no rows are read. Every answer and every refusal is written to the audit log.
• Data Operations sees individual records to check a claim with the insurer. The claim number is the link. Name and mobile number stay hidden.
• For the Analyst, counts under 10 are hidden so a small count cannot point to one person. Counts of 10 or more show in full.
• Figures and sample values from other roles show only where your own role may see them.

SELECT claim_no, rto_code, report_date, holder_name, holder_mobile
FROM srv_theft_claim_holders
WHERE rto_code IN ('TS09', 'TS10', 'TS11', 'TS12', 'TS13')
  AND report_date BETWEEN DATE '2025-10-01' AND DATE '2026-09-30'
ORDER BY report_date DESC, claim_no

SELECT rto_code, CAST(SUM(claims) AS BIGINT) AS theft_claims
FROM srv_claims_weekly
WHERE state_code = 'TS' AND claim_type = 'THEFT' AND cycle BETWEEN '2025-10' AND '2026-09'
GROUP BY rto_code
ORDER BY theft_claims DESC, rto_code

SELECT state_name, CAST(SUM(claims) AS BIGINT) AS theft_claims
FROM srv_claims_weekly
WHERE claim_type = 'THEFT' AND cycle BETWEEN '2025-10' AND '2026-09'
GROUP BY state_name
ORDER BY theft_claims DESC, state_name

Each question asked of the data is logged with the time, role and page. Mobile, email, registration and chassis numbers typed into a question are removed before it is stored. Showing the latest 15 of 199.

The role checks above just ran and added 12 entries to the log, one per question and role. They show here from your next visit. The checks run again only when the app restarts or the data changes.