Help Center/ MapReduce Service/ Component Operation Guide (LTS)/ Using ClickHouse/ ClickHouse User Permission Management/ ClickHouse User Rights
Updated on 2024-12-13 GMT+08:00
View PDF
Share

ClickHouse User Rights

User Permission Model

ClickHouse user permission management enables unified management of users, roles, and permissions on each ClickHouse instance in the cluster. You can use the permission management module of the Manager UI to create users, create roles, and bind the ClickHouse access permissions. User permissions are controlled by binding roles to users.

  • Resource management: Table 1 lists the resources supported by ClickHouse permission management.
  • Resource permissions: Table 2 lists the resource permissions supported by ClickHouse.
Table 1 Permission management objects supported by ClickHouse

Resource

Integration

Remarks

Database

Yes (level 1)

-

Table

Yes (level 2)

-

View

Yes (level 2)

Same as tables
Table 2 Resource permission list

Resource

Available Permission

Remarks

Database

CREATE

CREATE DATABASE/TABLE/VIEW/DICTIONARY

Table/View

SELECT/INSERT

-