v.25.6Improvement

Allow read-only mode

Official CH changelog text
Allow read-only mode for the merge table function, so the CREATE TEMPORARY TABLE grant is not required for using it. #80981 (Miсhael Stetsyuk).
Allow the merge table function to operate in read-only mode without requiring the CREATE TEMPORARY TABLE privilege.

Why it matters

This feature removes the need for users to have the CREATE TEMPORARY TABLE grant to use the merge table function, enhancing security and simplifying permissions management when querying merged tables.

How to use it

Users can now use the merge table function as usual without any additional privilege if only read-only access is required. No changes to existing queries or permission grants are necessary to benefit from this improvement.

Related resources

PreviousNext