v.1.1.54337New Feature

Users with readonly = 2 Can Work with TEMPORARY Tables

Official CH changelog text
Users with the readonly = 2 setting are allowed to work with TEMPORARY tables (CREATE, DROP, INSERT…) (Kirill Shvakov).
Allows users with readonly = 2 setting to work with TEMPORARY tables, enabling operations like CREATE, DROP, and INSERT on them.

Why it matters

Previously, users with readonly = 2 could not manipulate TEMPORARY tables, which limited their ability to perform session-specific or temporary data operations. This feature provides more flexibility by allowing such users to create and manage TEMPORARY tables, facilitating temporary data processing and testing without requiring higher privileges.

How to use it

Assign the user setting readonly = 2. Such users can then execute CREATE TEMPORARY TABLE, DROP TEMPORARY TABLE, and INSERT INTO TEMPORARY TABLE statements normally within their sessions, enabling temporary data manipulations without elevated permissions.
PreviousNext