-
Notifications
You must be signed in to change notification settings - Fork 8.3k
Readonly not working as documented #43068
Copy link
Copy link
Closed
Labels
need-docsDocs are missing or innacurateDocs are missing or innacurate
Description
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.
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
need-docsDocs are missing or innacurateDocs are missing or innacurate