oracle-databasepasswordscreateuser

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?


Solution

  • 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