Hi,
If I execute:
root:~# clickhouse-client --user default --password ******
ClickHouse client version 21.9.4.35 (official build).
Connecting to localhost:9000 as user default.
Connected to ClickHouse server version 21.9.4 revision 54449.
clickhouse-1 :) GRANT ALL ON DM_ITRAVEX.* TO USR_ITRAVEX;
GRANT SHOW, SELECT, INSERT, ALTER, CREATE DATABASE, CREATE TABLE, CREATE VIEW, CREATE DICTIONARY, DROP, TRUNCATE, OPTIMIZE, SYSTEM MERGES, SYSTEM TTL MERGES, SYSTEM FETCHES, SYSTEM MOVES, SYSTEM SENDS, SYSTEM REPLICATION QUEUES, SYSTEM DROP REPLICA, SYSTEM SYNC REPLICA, SYSTEM RESTART REPLICA, SYSTEM RESTORE REPLICA, SYSTEM FLUSH DISTRIBUTED, dictGet ON DM_ITRAVEX.* TO USR_ITRAVEX
Query id: 4431edbc-c1e6-4651-a071-37b9c9bfe259
Ok.
0 rows in set. Elapsed: 0.003 sec.
Then it works.
Joan.