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
/

2 comments:

Anonymous said...

Call4Papers Deadline: 03/31/2011 GetPaid2Speak! No Travel Required! #VirtaThon | The online conference for the Oracle, Java & MySQL Communites http://www.virtathon.com

yaklibber924 said...

Would you be excited about exchanging hyperlinks? free online casino slots