Skip to content

ezgh warehouse users create

Create a user.

Updated View as Markdown
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"]}]' --wait

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 available, and print it then
--wait-timeout duration 10m0s how long --wait waits

This command also takes the global flags.

Navigation

Type to search…

↑↓ navigate↵ selectEsc close