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: [{“database”:“events”,“table”:“*”,“privileges”:[“SELECT”,“INSERT”]}], 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.
Flags
| Flag | Type | Default | Description |
|---|---|---|---|
--grants |
string | custom’s grants as the API’s JSON: [{“database”:“events”,“table”:“*”,“privileges”:[“SELECT”]}] | |
--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.