---
title: "List all user-id to role mappings for JIT access"
method: GET
path: "/v1/projects/{ref}/database/jit/list"
tags: ["Database"]
---

# List all user-id to role mappings for JIT access

`GET /v1/projects/{ref}/database/jit/list`

Mappings of roles a user can assume in the project database

## Path parameters

- `ref` string, required

## Response `200`

- JitListAccessResponse
  - `items` union[], required
    - union
      - object
        - `user_id` string, uuid, required
        - `primary_email` string, nullable, required
        - `invite_id` unknown, required
        - `expires_at` unknown, required
        - `user_roles` object[], required
          - `role` string, required
          - `expires_at` number
          - `allowed_networks` object
            - `allowed_cidrs` object[]
              - …
            - `allowed_cidrs_v6` object[]
              - …
          - `branches_only` boolean
      - object
        - `user_id` unknown, required
        - `primary_email` string, required
        - `invite_id` string, uuid, required
        - `expires_at` string, required
        - `user_roles` object[], required
          - `role` string, required
          - `expires_at` number
          - `allowed_networks` object
            - `allowed_cidrs` object[]
              - …
            - `allowed_cidrs_v6` object[]
              - …
          - `branches_only` boolean

## Other responses

- `401` — Unauthorized
- `403` — Forbidden action
- `429` — Rate limit exceeded
- `500` — Failed to list database jit access

---

[API](https://skmtc.dev/supabase/apis/management-api.md) · [All operations](https://skmtc.dev/supabase/apis/management-api/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/supabase/management-api/revisions/a7cb39418064/schema)