Admin-rights review: exportable list of every admin with source, last sign-in and last review (BSI ORP.4.A3, BK AR012) #888

Closed
opened 2026-10-12 21:34:59 +00:00 by Cordy · 2 comments
Owner

This came out of the #880 research (scratch/b7e/880-bsi-verify.md).

Why:

  • BSI IT-Grundschutz ORP.4.A3 (Basis) requires that administrative rights are reviewed regularly ("MUSS").
  • The Swiss BK AR012 PAM principles (Prinzip 10) ask for regular review.
  • NIST AC-6(7) asks for review of user privileges.
  • Today an operator has to assemble this by hand from several places: config file, dashboard grants, local accounts, IdP admin groups.

Idea:

  • Users & access gets a review view, or Overview gets a card, listing every administrator. For each one it shows:
    • the source (config break-glass / local / dashboard grant / IdP group);
    • the last sign-in (from #887);
    • when the rights were last reviewed and by whom.
  • A "Mark reviewed" action writes an audit entry.
  • CSV/PDF export for audits.

Effort: about 2–4 days.

Needs first:

  • #887 (last sign-in);
  • research on how competitors do access reviews (Entra access reviews, GitLab, Nextcloud);
  • a mockup.

Standards: once shipped, add a row to docs/handbook/security-standards.md.

This came out of the #880 research (`scratch/b7e/880-bsi-verify.md`). **Why:** - BSI IT-Grundschutz ORP.4.A3 (Basis) requires that administrative rights are reviewed regularly ("MUSS"). - The Swiss BK AR012 PAM principles (Prinzip 10) ask for regular review. - NIST AC-6(7) asks for review of user privileges. - Today an operator has to assemble this by hand from several places: config file, dashboard grants, local accounts, IdP admin groups. **Idea:** - Users & access gets a review view, or Overview gets a card, listing every administrator. For each one it shows: - the source (config break-glass / local / dashboard grant / IdP group); - the last sign-in (from #887); - when the rights were last reviewed and by whom. - A "Mark reviewed" action writes an audit entry. - CSV/PDF export for audits. **Effort:** about 2–4 days. **Needs first:** - #887 (last sign-in); - research on how competitors do access reviews (Entra access reviews, GitLab, Nextcloud); - a mockup. **Standards:** once shipped, add a row to `docs/handbook/security-standards.md`.
Author
Owner

Mockup (2026-10-13)

888-admin-review-mockup.html, revision 2, waiting for Nikola's approval.

Placement

  • Everything goes in one new tab, Users & access › Reviews & reports, named the same as Sharing's tab so operators find it by analogy.
  • Sharing › Reviews & reports is not touched (Nikola: operators would not look for this under Sharing).

What the tab shows

  • The review, at the top:
    • a "Due" chip and "N need a look";
    • the list, with flagged rows first (never signed in, or no sign-in for more than 90 days);
    • row actions;
    • Create report and Mark as reviewed (with an optional note).
  • "Reminders and reports", below:
    • a switch (the "do we have to check" decision);
    • the interval (default 6 months, decided);
    • who gets the reminder;
    • the scheduled report (PDF/CSV, folder, recipients).
  • When reminders are off: a one-click "Turn on, every 6 months" bar at the top.

Reminder: an Overview notice plus a bell item, both leading to the tab.

## Mockup (2026-10-13) `888-admin-review-mockup.html`, revision 2, waiting for Nikola's approval. **Placement** - Everything goes in **one new tab, Users & access › Reviews & reports**, named the same as Sharing's tab so operators find it by analogy. - Sharing › Reviews & reports is not touched (Nikola: operators would not look for this under Sharing). **What the tab shows** - **The review, at the top:** - a "Due" chip and "N need a look"; - the list, with flagged rows first (never signed in, or no sign-in for more than 90 days); - row actions; - Create report and Mark as reviewed (with an optional note). - **"Reminders and reports", below:** - a switch (the "do we have to check" decision); - the interval (default 6 months, decided); - who gets the reminder; - the scheduled report (PDF/CSV, folder, recipients). - **When reminders are off:** a one-click "Turn on, every 6 months" bar at the top. **Reminder:** an Overview notice plus a bell item, both leading to the tab.
Author
Owner

Mockup revision 3 approved (Nikola, 2026-10-13). Users & access gets two new tabs:

  • Admin review:
    • status card;
    • filters (All / Needs a look / Emergency / source / search);
    • paging (20 to 500 per page);
    • row actions;
    • Create report and Mark as reviewed;
    • a bar to turn reminders on when they are off.
  • Reminders & reports: reminders (switch, default interval 6 months, recipients), scheduled report, and a history of reviews and reports.

Built together with #887 in batch-v07j (v0.6.336).

**Mockup revision 3 approved (Nikola, 2026-10-13).** Users & access gets two new tabs: - **Admin review:** - status card; - filters (All / Needs a look / Emergency / source / search); - paging (20 to 500 per page); - row actions; - Create report and Mark as reviewed; - a bar to turn reminders on when they are off. - **Reminders & reports:** reminders (switch, default interval 6 months, recipients), scheduled report, and a history of reviews and reports. Built together with #887 in batch-v07j (v0.6.336).
Cordy closed this issue 2026-10-13 01:50:55 +00:00
Sign in to join this conversation.
No labels
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference: Cordy/Cairn#888
No description provided.