Skip to content

ezgh warehouse users update

Change a user's permissions or settings profile.

Updated View as Markdown
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.

Navigation

Type to search…

↑↓ navigate↵ selectEsc close