v.18.12New Feature

Added allow_ddl Option to Restrict DDL Query Access

Official CH changelog text
Added the allow_ddl option, which restricts the user’s access to DDL queries. #3104
Introduced the allow_ddl option to control user permissions for executing DDL queries in ClickHouse.

Why it matters

This feature restricts access to Data Definition Language (DDL) queries, enhancing security and preventing unauthorized schema changes by limiting which users can perform such operations.

How to use it

Set the allow_ddl option for a user in the user profile configuration to true to allow DDL queries or false to deny them.

Related resources

PreviousNext