data-api-builder-auth-mastery
Deep guide for choosing and configuring Data API Builder authentication providers and the role/claim flow end to end.
用 Codex 或 Claude 帮你安装 复制这段 Prompt,粘贴到 Codex、Claude 或其他助手里,让它检查 Skill 页面并帮你完成安装。
菜单
Deep guide for choosing and configuring Data API Builder authentication providers and the role/claim flow end to end.
用 Codex 或 Claude 帮你安装 复制这段 Prompt,粘贴到 Codex、Claude 或其他助手里,让它检查 Skill 页面并帮你完成安装。
基于 SOC 职业分类
Run SQL Commander as a companion container for browser-based SQL access, with optional Azure Container Apps configuration.
Orchestrate SQL Server and Data API Builder with .NET Aspire for local development, health-aware startup, and dashboard-driven diagnostics.
Add MCP Inspector to .NET Aspire AppHost for local SQL MCP Server validation and tool discovery.
Add SQL Commander to .NET Aspire for lightweight SQL browsing and query execution during local DAB development.
Use SQL Database Projects (.sqlproj) with .NET Aspire for declarative schema deployment via dacpac.
Deploy Data API Builder and SQL MCP Server to Azure App Service for Linux, with or without containers.
| name | data-api-builder-auth-mastery |
| description | Deep guide for choosing and configuring Data API Builder authentication providers and the role/claim flow end to end. |
| license | MIT |
runtime.host.authentication with jwt.audience / jwt.issuer.X-MS-API-ROLE, entity permissions, and claim-backed policies.Unauthenticated — default; DAB validates no identity and every request is Anonymous.StaticWebApps — Azure Static Web Apps platform identity headers.AppService — EasyAuth; trusts X-MS-CLIENT-PRINCIPAL and claims injected by App Service.EntraID / AzureAD — Microsoft Entra JWT bearer; requires jwt.audience and jwt.issuer.Custom — generic OIDC/JWT providers (Okta, Auth0, Keycloak); also requires jwt.audience and jwt.issuer.Simulator — development mode only; defaults to Authenticated and lets X-MS-API-ROLE choose test roles.Unauthenticated; Azure host → StaticWebApps/AppService; Entra → EntraID; third-party JWT → Custom; local role testing → Simulator.runtime.host.authentication.provider; add jwt.audience + jwt.issuer only for JWT providers.permissions as [{ role, actions }]; use valid actions: create, read, update, delete, execute, *.roles claim (or platform role claims) and send X-MS-API-ROLE: <role>.Authenticated, and each custom-role path.Anonymous; valid identity with no X-MS-API-ROLE → Authenticated.X-MS-API-ROLE header; missing membership is 403.Simulator; DAB rejects it outside development mode.Custom is the provider name for generic JWT, not Jwt.Unauthenticated can't drive claim policies, custom roles, or Authenticated permissions.data-api-builder-authdata-api-builder-rls-policiesdata-api-builder-config