clickhouse-cloud-management

Create ClickHouse Cloud users by executing CREATE USER SQL commands over HTTP via curl. Grant specific database and table permissions using GRANT statements, revoke access with REVOKE, and verify user configurations with SHOW USERS to audit permissions across your deployment.

API keys authenticate management operations against the ClickHouse Cloud control plane for infrastructure tasks, while database users authenticate SQL queries directly to databases. Each serves different scopes: API keys for provisioning and cloud console access, database users for query execution and data access control.

Test connectivity by executing SQL commands through the HTTP interface on port 443 using curl with proper credentials. Verify user permissions match the intended role, confirm password policies meet ClickHouse requirements, and check GRANT configurations to isolate whether the issue is authentication or authorization.

Yes, ClickHouse Cloud enforces strong password policies automatically when creating users via SQL. The HTTP interface validates password strength requirements during CREATE USER execution, ensuring credentials meet security standards without manual configuration.

ClickHouse Cloud supports CREATE USER to add users, GRANT to assign database and table permissions, DROP USER to remove users, and SHOW USERS to list all users and their roles. Execute these commands over HTTP using curl with SQL syntax patterns specific to your permission model.