How it works
Before
- Engineer
- raises a ticket
removed: DevOps queue14 days on average- done by hand
- Database or server
After
- Engineer
- requests, with a reason
- Approvermanager or data owner
- accepts
- Portalruns it under access rules
- logs it
- Audit trailin Jira
Engineers choose from supported actions: database queries, Kafka, GitHub, Redash and API gateway requests. Risky actions, like changing a live MySQL table, need a second sign-off from DevOps.
What I left out
Direct access for everyone was fast but unsafe. A bigger queue was safe but slow. The portal runs approved actions under rules instead.
What happened
- 20,000+ requests went through the portal.
- The average wait fell from 14 days to 17 minutes.
- Every grant has a requester, an approver and a time.
One part is written up in detail: automating Redash permissions.