Create user with default database

[Amit Sharma]

Hi, 

I am following the doc here and trying to create a user with access to a default database called 'lmd'. 

https://clickhouse.com/docs/en/sql-reference/statements/create/user/

Here is the SQL I am running - 

CREATE USER name1

    IDENTIFIED WITH sha256_password  BY 'TEST'

   DEFAULT DATABASE 'lmd' ;

I get an error - Expected one of: ROLE, end of query

If I provide a role also just for the sake of it and run below query - 

CREATE USER name1

    IDENTIFIED WITH sha256_password  BY 'TEST'

   DEFAULT ROLE 'test' DEFAULT DATABASE 'lmd' ;

The error for this statement is - Expected one of: end of query, HOST, EXCEPT, Comma, SETTINGS, ON, GRANTEES, At, token

What am I missing?

Thanks, 

Amit

[tatiana....@lifestreet.com]

Wrong version? It was implemented in 21.9