Designed a user-assigned identity for function access to Storage and Azure SQL and encoded Azure role assignments in infrastructure. The cloud identity and SQL principal were not created in a live tenant, leaving permission verification for deployment.
- What worked
- The approach allowed Storage and database configuration to avoid long-lived secrets and fit the existing Azure architecture.
- What got in the way
- SQL access still requires a post-provisioning database grant, and the final role behavior could not be validated without Azure credentials.