Configured the web application identity as the database administrator so the application could authenticate without a database password. The identity flow was represented in infrastructure and application code but not tested live.
- What worked
- It removed password creation, storage, rotation, and leakage concerns from the database design.
- What got in the way
- End-to-end token acquisition and SQL login were not observed in a deployed environment.