# Users: Nextcloud Nextcloud Users ## Documentation Users of the Nextcloud server, one row per user. Requires an administrator; an ordinary user sees themselves only. Insert creates a user, update changes one column at a time, and delete removes the user. - Catalog: `Nextcloud` - Schema: `Nextcloud` - Primary Keys: `user_id` - Label: Nextcloud Users Can retrieve data and change data using insert, update and delete. ## Columns of Table Function The columns of the table function `Users` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `address` | `varchar2` | | ☐ | Address. | | `backend` | `varchar2` | | ☐ | Where the account is administered, such as Database or LDAP. | | `biography` | `varchar2` | | ☐ | Biography of the profile. | | `can_set_display_name` | `char` | | ☐ | Whether the backend allows the display name to be changed. | | `can_set_password` | `char` | | ☐ | Whether the backend allows the password to be changed. | | `display_name` | `varchar2` | | ☐ | Name shown to other users. | | `email` | `varchar2` | | ☐ | Primary email address. | | `enabled` | `char` | | ☐ | Whether the user may log on. Written through a dedicated enable or disable route rather than a plain field update. | | `first_logon_date` | `datetime` | | ☐ | Moment the user logged on for the first time (UTC). Empty where the user never logged on. | | `headline` | `varchar2` | | ☐ | Headline of the profile. | | `id` | `varchar2` | | ☐ | Identifier of the user as reported inside the user object. | | `language` | `varchar2` | | ☐ | Language of the user interface. | | `last_logon_date_ms` | `datetime` | | ☐ | Moment the user logged on most recently (UTC), as Nextcloud reports it in milliseconds beside the same value in seconds. Empty where the user never logged on. | | `last_logon_date` | `datetime` | | ☐ | Moment the user logged on most recently (UTC). Empty where the user never logged on. | | `locale` | `varchar2` | | ☐ | Locale used for formatting. | | `manager` | `varchar2` | | ☐ | Login name of the manager of the user. | | `notify_email` | `varchar2` | | ☐ | Address notifications are sent to when it differs from the primary one. | | `organisation` | `varchar2` | | ☐ | Organisation. | | `password` | `varchar2` | | ☐ | Password of the user. Write-only: never answered on a read, accepted on insert and on update. | | `phone` | `varchar2` | | ☐ | Telephone number. | | `profile_enabled` | `varchar2` | | ☐ | Whether the profile is shown; answered as the text 0 or 1 rather than as a boolean, and written the same way. | | `pronouns` | `varchar2` | | ☐ | Pronouns of the user as they stated them. | | `quota_free_bytes` | `int64` | | ☐ | Bytes still available; a negative number means unlimited or unknown. | | `quota_relative` | `decimal` | | ☐ | Percentage of the quota in use. | | `quota_total_bytes` | `int64` | | ☐ | Effective quota in bytes, after any group-based override; a negative number means unlimited or unknown. Read-only - write through the quota column, which is the configured value. | | `quota_used_bytes` | `int64` | | ☐ | Bytes in use. | | `quota` | `int64` | | ☐ | Quota as configured, beside the effective total in quota_total_bytes. Writable in bytes, though Nextcloud does not list it among the fields it declares as writable. | | `role` | `varchar2` | | ☐ | Role within the organisation. | | `storage_location` | `varchar2` | | ☐ | Folder on the server holding the files of the user. | | `timezone` | `varchar2` | | ☐ | Time zone of the user. | | `user_id` | `varchar2` | | ☑ | Login name of the user. Required on insert; the where clause of an update or delete, never a value either writes. | | `website` | `varchar2` | | ☐ | Website. |