Skip to content

Instantly share code, notes, and snippets.

@Slach
Created October 24, 2023 18:16
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Slach/385033959741d2f144747858782df37a to your computer and use it in GitHub Desktop.
Save Slach/385033959741d2f144747858782df37a to your computer and use it in GitHub Desktop.
add XML users grants example
services:
clickhouse:
image: ${CLICKHOUSE_IMAGE:-clickhouse/clickhouse-server}:${CLICKHOUSE_VERSION:-latest}
volumes:
- ./xml_user_grants.xml:/etc/clickhouse-server/users.d/xml_user_grants.xml
<clickhouse>
<users>
<another>
<password/>
<networks>
<ip>::/0</ip>
</networks>
<profile>default</profile>
<quota>default</quota>
<grants>
<query>GRANT SHOW ON *.*</query>
<query>GRANT CREATE ON *.* WITH GRANT OPTION</query>
<query>GRANT SELECT ON system.*</query>
<query>REVOKE CREATE ON system.*</query>
</grants>
</another>
<admin_user>
<password/>
<networks>
<ip>::/0</ip>
</networks>
<profile>default</profile>
<quota>default</quota>
<grants>
<query>GRANT admin_role</query>
</grants>
</admin_user>
</users>
<roles>
<test_role>
<grants>
<query>GRANT SHOW ON *.*</query>
<query>REVOKE SHOW ON system.*</query>
<query>GRANT CREATE ON *.* WITH GRANT OPTION</query>
</grants>
</test_role>
<admin_role>
<grants>
<query>GRANT ALL ON *.* WITH GRANT OPTION</query>
</grants>
</admin_role>
</roles>
</clickhouse>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment