Is it possible to allow remote function for readonly user?

[Max G]

message":"failed to query  select count(*) from remote('localhost,node1', 'default', 'visitors') []: Code: 164, Message: Table functions are forbidden in readonly mode

I've got this error when used "readonly" user.

I want to restrict access to changing the tables, but it's important to keep the ability to read everything users want.

I didn't find in docs specific rule for "table functions".

Is it possible?

[Denis Zhuravlev]

try value 2

https://clickhouse.yandex/docs/en/operations/settings/query_complexity/#query_complexity_readonly

[Max G]

Yes, thank you. It works.

четверг, 9 августа 2018 г., 19:49:00 UTC+3 пользователь Denis Zhuravlev написал:

try value 2

https://clickhouse.yandex/docs/en/operations/settings/query_complexity/#query_complexity_readonly