CODEWITHSUNDEEP
oracle-databasepasswordscreateuser
inanutshellus
inanutshellus

Reputation: 10001

ORA-00988: missing or invalid password(s)

I'm trying to change an oracle password:

alter user FOO identified by 'BAR';

and I'm getting the following back:

Error starting at line 120 in command:
alter user FOO identified by 'BAR'
Error report:
SQL Error: ORA-00988: missing or invalid password(s)
00988. 00000 -  "missing or invalid password(s)"

What's going on?

Upvotes: 23

Views: 48429

Answers (3)

David Lipschitz
David Lipschitz

Reputation: 152

alter user davidl identified by "newpassword" replace "oldpassword";

Upvotes: 3

Zeus
Zeus

Reputation: 6566

For me I was altering two users in the same script file, which did not work. I had to alter them in a different script files.

Sql tool: Golden

Upvotes: 0

inanutshellus
inanutshellus

Reputation: 10001

Turns out one doesn't put the password in single quotes. Double quotes are required if the password contains some special characters.

alter user FOO identified by 'BAR'; -- Broken
alter user FOO identified by BAR;   -- Works
alter user FOO identified by "BAR"; -- Works

Upvotes: 62

Related Questions