# SheetShares ## Documentation Who a sheet is shared with, and with which rights. A filter on sheet_id reads one sheet only. - Catalog: `Smartsheet` - Schema: `Sheets` - Primary Keys: `sheet_id, share_id` This is a read-only table. The Smartsheet API may not support changing the data or the Invantive UniversalSQL driver for Smartsheet does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Smartsheet API. ## Table Columns The columns of the table `SheetShares` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `access_level` | `varchar2` | | ☐ | The rights given: VIEWER, COMMENTER, EDITOR, EDITOR_SHARE, ADMIN or OWNER. | | `email` | `varchar2` | | ☐ | The e-mail address of the user shared with. | | `group_id` | `int64` | | ☐ | The group shared with, for a share with a group. | | `name` | `varchar2` | | ☐ | The name of the user or group shared with. | | `scope` | `varchar2` | | ☐ | ITEM for a share of the sheet itself, WORKSPACE for a share through its workspace. | | `share_id` | `varchar2` | | ☑ | The id of the share. | | `sheet_id` | `int64` | | ☑ | The sheet shared. | | `type` | `varchar2` | | ☐ | USER or GROUP. | | `user_id` | `int64` | | ☐ | The user shared with, for a share with a user. | ## Foreign Keys The values of these columns refer to a row of another table. | Columns | Referenced Table | Referenced Columns | Guarantee | |---|---|---|---| | `group_id` | [[Users-Groups\|Users.Groups]] | `group_id` | In words only: Holds for a group of the organisation. | | `sheet_id` | [[Sheets-Sheets\|Sheets.Sheets]] | `sheet_id` | Declared by the connector, not enforced by the platform | | `user_id` | [[Users-Users\|Users.Users]] | `user_id` | In words only: Holds for a user of the organisation; a sheet may be shared with someone outside it. |