O nome do usuário é após o CREATE USER ou após o IDENTIFIED BY

Tive essa mesma percepção. Fui no oracle tutorial para tirar a dúvida e após o IDENTIFIED BY é sim o password.

Compartilhando contigo o link e a instrução.

https://www.oracletutorial.com/oracle-administration/oracle-create-user/

CREATE USER username IDENTIFIED BY password [DEFAULT TABLESPACE tablespace] [QUOTA {size | UNLIMITED} ON tablespace] [PROFILE profile] [PASSWORD EXPIRE] [ACCOUNT {LOCK | UNLOCK}];

Oracle CREATE USER examples Let’s practice with the CREATE USER statement.

1) Using Oracle CREATE USER statement to create a new local user example This example uses the CREATE USER statement to create a new local user named john with the password abcd1234:

CREATE USER john IDENTIFIED BY abcd1234;

Code language: SQL (Structured Query Language) (sql)

Oracle issues the following output indicating that user john has been created successfully.

User JOHN created.