v.24.8Improvement

Do not require a grant for REMOTE in Distributed table creation

Official CH changelog text
Do not require a grant for REMOTE when creating a Distributed table: a grant for the Distributed engine is enough. #65419 (jsc0218).
Do not require a separate REMOTE grant when creating a Distributed table; having a grant for the Distributed engine is sufficient.

Why it matters

This feature simplifies permission management by removing the need for an explicit REMOTE grant when working with Distributed tables. Users now only require the grant for the Distributed engine itself, reducing complexity and potential permission errors.

How to use it

When creating Distributed tables, ensure the user has the appropriate grant for the Distributed engine. No additional REMOTE grants are needed.

Related resources

PreviousNext