Skip to content

Readonly not working as documented #43068

@dbanda

Description

@dbanda

The docs say "readonly — Restricts permissions for all types of queries except DDL queries"

But if I do:

SET readonly=2
SET allow_ddl=1
create table test_ddl (id String) engine = Merge('default', 'test_ddl' )

I get :

Code: 164. DB::Exception: Received from localhost:9000. DB::Exception: default: Cannot execute query in readonly mode. (READONLY)

what's the correct way to allow executing DDL queries in readonly mode? The docs say readonly should not restrict DDL queries.

Metadata

Metadata

Assignees

Labels

need-docsDocs are missing or innacurate

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions