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