gistfile1.txt

https://github.com/ClickHouse/ClickHouse/issues/47092#issuecomment-1485052499

23.3.8.21
<default>
   <access_management>1</access_management>
</default>

create user foo;
grant all on *.* to foo;

Received exception from server (version 23.3.8):
Code: 497. DB::Exception: Received from localhost:9000. DB::Exception: default: 
Not enough privileges. To execute this query it's necessary to have grant 
SHOW, SELECT, INSERT, ALTER, CREATE, DROP, UNDROP TABLE, TRUNCATE, OPTIMIZE, BACKUP, KILL QUERY, 
KILL TRANSACTION, MOVE PARTITION BETWEEN SHARDS, ACCESS MANAGEMENT, 
NAMED COLLECTION CONTROL, SYSTEM, dictGet, INTROSPECTION, SOURCES ON *.* WITH GRANT OPTION. (ACCESS_DENIED)



-------------
<default>
    <access_management>1</access_management>
    <named_collection_control>1</named_collection_control>
    <show_named_collections>1</show_named_collections>
    <show_named_collections_secrets>1</show_named_collections_secrets>
</default>
        
        
grant all on *.* to foo;
        
Ok.

0 rows in set. Elapsed: 0.001 sec.