ORA-01938: IDENTIFIED BY must be specified for CREATE USER

文档解释

ORA-01938: IDENTIFIED BY must be specified for CREATE USER

Cause: Cannot create a user without specifying a password or “IDENTIFIED EXTERNALLY”.

Action: Specify one of the password clauses.

ORA-01938: IDENTIFIED BY must be specified for CREATE USER是在创建新用户时必须指定用户的 Identified By 密码参数的报错信息。通过修改 CREATE USER 语句，指定 Identified By 密码参数，可以解决本错误。

官方解释

ORA-01938: IDENTIFIED BY must be specified for CREATE USER

Cause: An IDENTIFIED BY clause must be specified in the CREATE USER statement.

Action: Specify an IDENTIFIED BY clause in the CREATE USER statement.

常见案例

比如，在创建用户名为test_user，密码为test_password的新用户时，不指定 Identified By 密码参数，将报这个错：

SQL> CREATE USER test_user;

ERROR at line 1:

ORA-01938: IDENTIFIED BY clauses must be specified for each user.

正常处理方法及步骤

1. 修改 CREATE USER 语句，指定 Identified By 密码参数：

SQL> CREATE USER test_user IDENTIFIED BY test_password;

2. 确认是否修改成功：

SQL> SELECT * FROM dba_users WHERE username=’TEST_USER’;

USERNAME USER_ID PASSWORD EXP

——– ———- ———– —

TEST_USER 119 E4F4F4EC4E84FCE9E583199C781DFCEF

0