---
title: "ezgh warehouse users update"
description: "Change a user's permissions or settings profile."
---

> Documentation Index
> Fetch the complete documentation index at: https://docs.ezghcloud.com/llms.txt
> Use this file to discover all available pages before exploring further.

# ezgh warehouse users update

{/* Generated by ezgh-cli's internal/tools/clidocs from the ezgh command tree. Don't edit: change the command's help in ezgh-cli and regenerate. */}

```sh
ezgh warehouse users update <warehouse> <user> [--preset p [--grants json]] [--settings-profile p] [--wait] [flags]
```

Replace a user's permissions, or change its settings profile. They apply without a restart. Presets: admin (everything in every database, every connection, other users' queries), readWrite (select, insert, alter and table DDL in every database), readOnly (select and show) or custom, whose grants go in `--grants` as the API's JSON: \[&#123;"database":"events","table":"\*","privileges":\["SELECT","INSERT"\]&#125;\], where table is a table's name or \* and privileges are SELECT, INSERT, ALTER, CREATE, DROP, TRUNCATE, OPTIMIZE and SHOW. `--settings-profile` is default, heavy or light.

Part of [`ezgh warehouse users`](/cli/reference/warehouse-users).

## Flags

| Flag | Type | Default | Description |
| --- | --- | --- | --- |
| `--grants` | string |  | custom's grants as the API's JSON: \[&#123;"database":"events","table":"\*","privileges":\["SELECT"\]&#125;\] |
| `--preset` | string |  | admin, readWrite, readOnly or custom (with `--grants`) |
| `--settings-profile` | string |  | default, heavy or light |
| `--wait` | boolean |  | wait until it's done, and print it then |
| `--wait-timeout` | duration | `10m0s` | how long `--wait` waits |

This command also takes the [global flags](/cli/reference#global-flags).

Source: https://docs.ezghcloud.com/cli/reference/warehouse-users-update/index.mdx
