Syntax error on updating Oracle database

[EdRev]

We have a Unix script that updates the password of our Oracle DB Users. Somehow we are getting Ora_00922: missing or invalid option when we supply a password with * (asterisk) at the end.
Since password is supplied by user, we can not control it. It is the same passowrd as ther domain password.

Any help will be greatly appreciated.

 

[hoinz]

I presume you use an SQL command like this:
alter user xxx identified by test*

It should work if you include the password in "":
alter user xxx identified by "test*"

But don't ask me what will happen if a user chooses a password with a " in it ...

regards

 

[Annihilannic]

Can you post the part of the script which updates the password? Maybe we can help you resolve it then.

Annihilannic.