Parece que a resposta dada como certa não é a adequada.
Parece que a resposta dada como certa não é a adequada.
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.