---
title: How to manage users in Scaleway Data Warehouse for ClickHouse®
description: Learn how to manage users in your Scaleway Data Warehouse for ClickHouse® deployment.
tags: manage users data warehouse ClickHouse® roles permissions admin administrator user
dates:
validation: 2025-06-03
posted: 2025-06-03
---
import Requirements from '@macros/iam/requirements.mdx'
This page explains how to manage users in your Data Warehouse for ClickHouse® deployment.
- A Scaleway account logged into the [console](https://console.scaleway.com)
- [Owner](/iam/concepts/#owner) status or [IAM permissions](/iam/concepts/#permission) allowing you to perform actions in the intended Organization
- Created a [Data Warehouse deployment](/data-warehouse/how-to/create-deployment/)
## How to manage users using the Scaleway console
The Scaleway console allows you to create users for your Data Warehouse for ClickHouse® deployment, to grant them admin rights, to update their password, and to delete them.
### How to create a user using the Scaleway console
1. Click **ClickHouse®** under **Data & Analytics** on the side menu. The Data Warehouse deployment page displays.
2. Click the name of the desired Data Warehouse deployment. The **Overview** tab of the deployment displays.
3. Click the **Users** tab. A list of your current users displays.
4. Click **+ Create user**. A pop-up displays.
5. Enter a username. It must be unique, contain up to 63 characters, and must start with a letter. Only alphanumeric characters, underscores, and dashes are accepted.
6. Enter a password, or generate one automatically.
7. Enable the toggle if you want to grant admin rights to the user.
8. Click **Create user** to proceed.
The newly created user appears in the list of your deployment's users.
### How to update a user's password and admin rights
1. Click **ClickHouse®** under **Data & Analytics** on the side menu. The Data Warehouse deployment page displays.
2. Click the name of the desired Data Warehouse deployment. The **Overview** tab of the deployment displays.
3. Click the **Users** tab. A list of your current users displays.
4. Click next to the name of the user you want to update, then click **Update user**. A pop-up displays.
5. Update the user's password and/or admin rights, then click **Update user** to confirm.
### How to delete a user using the Scaleway console
1. Click **ClickHouse®** under **Data & Analytics** on the side menu. The Data Warehouse deployment page displays.
2. Click the name of the desired Data Warehouse deployment. The **Overview** tab of the deployment displays.
3. Click the **Users** tab. A list of your current users displays.
4. Click next to the name of the user you want to delete. A confirmation pop-up displays.
5. Enter `DELETE`, then click **Delete user** to confirm.``
The user is deleted and no longer appears in the list.
## How to manage users using frameworks
[Connect to your deployment](/data-warehouse/how-to/connect-applications/) using your preferred framework.
You can also connect using the ClickHouse HTTP console from the **Overview** tab of your deployment. Make sure to enter valid credentials in the top-right fields.
Once connected, you can run SQL queries using `USER`, `ROLE`, and `ROW POLICY` to create new users and grant them the desired permissions via roles.
Refer to the official ClickHouse® documentation on [users and roles](https://clickhouse.com/docs/sql-reference/statements/create/user) for more information.
## Manage user permissions
[Connect to your deployment](/data-warehouse/how-to/connect-applications/) using your preferred framework.
Once connected, you can run SQL as shown below to grant the desired permissions to users.
**Grant permission to create databases**
```sql
GRANT CREATE DATABASE ON . TO user;
```
**Grant permission to create tables in any database**
```sql
GRANT CREATE TABLE ON . TO user;
```
**Grant permission to create tables in a specific database**
```sql
GRANT CREATE TABLE ON database_name.* TO user;
```
**Grant data manipulation permissions for any table in any database**
```sql
GRANT INSERT, UPDATE, DELETE ON . TO user;
```
**Grant data manipulation permissions for any table in a specific database**
```sql
GRANT INSERT, UPDATE, DELETE ON database_name.* TO user;
```
**Grant data manipulation permissions for a specific table in a specific database**
```sql
GRANT INSERT, UPDATE, DELETE ON database_name.table_name TO user;
```
**Grant every permissions on every database**
```sql
GRANT CREATE DATABASE, CREATE TABLE, INSERT, UPDATE, DELETE ON . TO user;
```