---
title: "List grants for a connection"
method: GET
path: "/v2/connections/{connectionId}/grants"
tags: ["Connections"]
---

# List grants for a connection

`GET /v2/connections/{connectionId}/grants`

## Request

- Base URL: `https://api.sigmacomputing.com`
- URL: `https://api.sigmacomputing.com/v2/connections/{connectionId}/grants`
- Auth: HTTP bearer

Get a list of permissions granted to users or teams on a specific connection.

### Usage notes
- Retrieve the **connectionId** by calling the [/v2/connections](https://help.sigmacomputing.com/reference/list-connections) endpoint.

## Path parameters

- `connectionId` string, required

## Query parameters

- `page` string
- `limit` number, double

## Response `200`

The response body.

- ConnectionsListConnectionGrantsResponse200
  - `entries` V2ConnectionsConnectionIdGrantsGetResponsesContentApplicationJsonSchemaEntriesItems[], required: Array of results returned by the endpoint
    - `grantId` string, required: The unique identifier of the grant
    - `inodeId` string, required: The unique identifier of the inode
    - `organizationId` string, required: The unique identifier of the organization
    - `memberId` string, nullable, required: The unique identifier of the member
    - `teamId` string, nullable, required: The unique identifier of the team
    - `permission` union, required: The permission granted to the member
      - 'admin' | 'annotate' | 'update' | 'usage' | 'writeback': Valid inode types: table, connection database, and connection schema.
      - 'create' | 'annotate' | 'organize' | 'explore' | 'view' | 'edit' | 'apply': Valid inode types: folder, workspace, workbook, dataset, and data model. Can Contribute permissions are listed as **organize** and Can Manage permissions are listed as **edit**.
      - 'view' | 'edit' | 'apply': Valid inode types: version tag.
    - `createdBy` string, required: The identifier of the user who created this grant
    - `updatedBy` string, required: The identifier of the user or process that last updated this grant
    - `createdAt` string, date-time, required: When the grant was created
    - `updatedAt` string, date-time, required: When the grant was last updated
  - `nextPage` string, nullable, required: Returns a string that can be used as the `page` parameter in the next request to fetch the next page of results. The last page of results returns `null`.
  - `total` number, double: Total number of results. Useful to determine if there is a need to paginate.
  - `hasMore` boolean: **[Deprecated]** Indicates whether more results are available.

---

[API](https://skmtc.dev/sigmacomputing/apis/sigma-rest-api.md) - [All operations](https://skmtc.dev/sigmacomputing/apis/sigma-rest-api/llms.txt) - [OpenAPI document](https://skmtc.dev/sigmacomputing/apis/sigma-rest-api/revisions/fb6036208c49?raw)