# Users ## Documentation The users of the organisation of the account. - Catalog: `Smartsheet` - Schema: `Users` - Primary Keys: `user_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 `Users` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `admin` | `char` | | ☐ | Whether the user is a system administrator. | | `email` | `varchar2` | | ☐ | The e-mail address the user logs on with. | | `first_name` | `varchar2` | | ☐ | The first name. | | `group_admin` | `char` | | ☐ | Whether the user may manage groups. | | `last_login` | `datetime` | | ☐ | When the user last logged on, UTC. | | `last_name` | `varchar2` | | ☐ | The last name. | | `licensed_sheet_creator` | `char` | | ☐ | Whether the user has a licence to create sheets. | | `name` | `varchar2` | | ☐ | The full name. | | `resource_viewer` | `char` | | ☐ | Whether the user may see resource views. | | `seat_type` | `varchar2` | | ☐ | The kind of licence seat, such as MEMBER or PROVISIONAL_MEMBER. | | `status` | `varchar2` | | ☐ | ACTIVE, PENDING or DECLINED. | | `user_id` | `int64` | | ☑ | The id of the user. | ## Referenced By The columns of these tables refer to a row of this table. | Table | Columns | Guarantee | |---|---|---| | [[Sheets-SheetShares\|Sheets.SheetShares]] | `user_id` | In words only: Holds for a user of the organisation; a sheet may be shared with someone outside it. | | [[Users-GroupMembers\|Users.GroupMembers]] | `user_id` | In words only: Holds for a member who is a user of the organisation. | | [[Users-Groups\|Users.Groups]] | `owner_user_id` | In words only: Holds for an owner who is a user of the organisation. |