ON CLUSTER sharding_6shard_1repl;
GRANT ON CLUSTER sharding_6shard_1repl ALL ON *.* TO Admin WITH GRANT OPTION;
DB::Exception: user: Not enough privileges. To execute this query it's necessary to have grant SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, ACCESS MANAGEMENT, NAMED COLLECTION CONTROL, SYSTEM, dictGet, INTROSPECTION, SOURCES ON *.* WITH GRANT OPTION. (ACCESS_DENIED)
у юзера user в конфиге прописано <access_management>1</access_management>
Что-то поменялось в ролевой модели? Но я что-то найти в доке не могу...
https://github.com/ClickHouse/ClickHouse/issues/47092#issuecomment-1485052499
Обсуждают сегодня