Task: Generate the schema fingerprint grant from its template
Table of Contents
This page documents a task in the Model the ORE report configuration as entities story. It captures the goal, current status, acceptance, and any notes or results.
1. Goal
Regenerating the service grants keeps every service able to read the schema fingerprint.
2. Status
| Field | Value |
|---|---|
| State | DONE |
| Parent story | Model the ORE report configuration as entities |
| Now | Nothing. |
| Waiting on | Nothing. |
| Next | Nothing. |
| Last touched | 2026-10-04 |
3. Acceptance
- The db grants template emits the fingerprint grant for every service in the registry.
- Regenerating the grants from the registry changes nothing in the checked-in file.
4. Plan
(Implementation strategy. Written when work starts; key decisions
are distilled into the parent story's * Decisions at close, but the
plan itself stays — it is the historical record of what we did.)
5. Measurements
Every number this task claims about a tree, with the command that produced it
and the commit it was measured at. A number without both is not a measurement,
because a clean-up record describes a tree and trunk moves under a branch: a
consumer count, a gate's component count and a suite's size all change with no
code changing, and the reader of a bare number cannot tell which tree it came
from. Where the raw output matters, put it in an evidence/ file beside the
task and name that file in the Command column.
| What | Value | Command | Commit |
|---|---|---|---|
6. Notes
7. Test Scenarios
Manual QA scenarios (scaffolded via compass add test_scenario)
that verify this task. Link
new ones here as they're created; the scenario doc itself links back
via its "Verifies task" field.
| Scenario | State | Notes |
|---|---|---|
8. PRs
| PR | Title |
|---|---|
| #2621 | [codegen] Generate the schema fingerprint grant from its template |
9. Review
| Comment summary | File | Decision | Notes |
|---|---|---|---|
10. Result
The db grants template now emits the schema fingerprint grant for every
service in the registry. #2574 had added it to the generated
iam_service_db_grants_create.sql by hand, so regenerating the grants from the
service registry, as any new service or grant change does, deleted it, and
every service would then have refused to start for want of SELECT on
ores_database_info_tbl. Regenerating the grants after this change leaves the
checked-in file byte-for-byte as it was.