Granting priviliges to a user in mssql (SQL server)

See more:

SQL-Server

I am trying create a database and connect it to Airflow to use it instead of it defaulting to SQLite. However, I am getting an error.

This is my SQL code:

CREATE DATABASE airflow;
ALTER DATABASE airflow SET READ_COMMITTED_SNAPSHOT ON;
CREATE LOGIN airflow_user WITH PASSWORD='airflow_pass123%';
USE airflow;
CREATE USER airflow_user FROM LOGIN airflow_user;
GRANT ALL PRIVILEGES ON DATABASE airflow TO airflow_user;

And this is the error:

Query 1 ERROR: Msg: 156, Line 7, State: 1, Level: 15
Incorrect syntax near the keyword 'TO'.

What I have tried:

I tried Googling the error, but with no success. Even following the exact syntax from the official doc did not help me.