Table engines in ClickHouse are now grantable, allowing for more granular permission control on table engines without affecting existing user behavior.
Why it matters
This feature enables administrators to grant permissions specifically on table engines, enhancing security and access management by controlling who can use or manage certain table engines. It solves the problem of coarse-grained permissions by introducing finer control, benefiting users who need stricter or more flexible permission settings.How to use it
Users can grant permissions on table engines using the standard GRANT statement in ClickHouse. Existing user privileges and behaviors remain unchanged, so enabling this feature is seamless. Simply use the GRANT command targeting table engines as needed in your access control management.