ezgh warehouse users create <warehouse> <name> [--preset p [--grants json]] [--settings-profile p] [--wait] [flags]Create a user. Its password is generated and written to a new Secret in the project, which users get names; ezgh never prints it. Names are lowercase letters, digits and underscores, starting with a letter; default and names starting ezgh_ are reserved. 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.
Examples
ezgh warehouse users create analytics grafana --preset readOnly --settings-profile light --wait
ezgh warehouse users create analytics loader --preset custom \
--grants '[{"database":"events","table":"*","privileges":["SELECT","INSERT"]}]' --waitFlags
| 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 available, and print it then | |
--wait-timeout |
duration | 10m0s |
how long --wait waits |
This command also takes the global flags.