Does ClickHouseHTTP support port 18123?

[WanchuangZhu]

I tried to connect to clickhouse database via port 18123. It returns an error message, saying: "the user Not enough privileges". I checked I have the full access.
How can I fix this?

The full error message is below:

Error in .local(conn, statement, ...) :
Code: 497. DB::Exception: user: Not enough privileges. To execute this query, it's necessary to have the grant SHOW DATABASES ON default.*. (ACCESS_DENIED) (version 24.3.2.23 (official build))

[patzaw]

Hi

The error is raised by ClickHouse itself and not the ClickHouseHTTP R package. It means that you could connect to the database but you don't have the privileges to run the query on the database.
If you think that you have full access to your ClickHouse instance, you should check if you connect to the right ClickHouse instance with the right user name. You can check your privileges with: dbGetQuery(con, "SHOW GRANTS")