Saturday, July 26, 2008

ORA-00988: missing or invalid password(s)

1040309

ORA-00988: missing or invalid password(s)

Cause: More usernames than passwords were specified in a GRANT statement. A valid password must be specified for each username listed in the GRANT statement.

Action: Enter a valid password for each username.


One of Reason is

User might trying to create the password with quotes.

Eg:

Alter User Team Identified by 'password'
/

Above statement will give error ORA-00988: missing or invalid password(s)


Modified by statement to

Alter User Team Identified by password
/