v.24.10New Feature

Allow Wildcard Prefix Access in GRANT SELECT Command

Official CH changelog text
Allow to grant access to the wildcard prefixes. GRANT SELECT ON db.table_pefix_* TO user. #65311 (pufit).
Allow granting access permissions to tables using wildcard prefixes in GRANT statements, enabling syntax like GRANT SELECT ON db.table_prefix_* TO user.

Why it matters

This feature simplifies managing permissions by allowing users to grant privileges on multiple tables sharing a common prefix without specifying each table individually. It reduces administrative overhead and enhances flexibility in access control.

How to use it

To use this feature, include a wildcard suffix in the GRANT statement to specify all tables with the given prefix. For example:

GRANT SELECT ON db.table_prefix_ TO user

Related resources

PreviousNext