DEV Community

Javier Vidal
Javier Vidal

Posted on • Edited on

How to create a read-only user in ClickHouse

#clickhouse

In ClickHouse, a settings profile is a collection of settings grouped under the same name. By default, there is a profile readonly that allows only read queries. This is from /etc/clickhouse-server/users.xml:

<yandex>
    <!-- Profiles of settings. -->
    <profiles>
        ...
        <!-- Profile that allows only read queries. -->
        <readonly>
            <readonly>1</readonly>
        </readonly>
    </profiles>
...
Enter fullscreen mode Exit fullscreen mode

So to create a read-only user we just have to:

CREATE USER username IDENTIFIED WITH plaintext_password BY 'qwerty' SETTINGS PROFILE 'readonly'
GRANT SHOW TABLES, SELECT ON database.* TO username
Enter fullscreen mode Exit fullscreen mode

Top comments (0)

Read next

bradi profile image

Is Anyone Here Familiar with Postman Repositories?

Brandon -

birddevelper profile image

Validation in Spring REST Framework

Bird -

wounddriver9 profile image

How to Grasp Concepts of Algorithms

Klinge Meldgaard -

bradi profile image

How to Fix the Issue of Not Being Able to View Your GitHub Account on Other Devices

Brandon -