Re: Alter user identified by with special chars

"Steven Fox" <steven.fox_at_dfas.mil> wrote in message news:256a75fa.0403040640.78bb13d4_at_posting.google.com...
> I have changed a password in OEM to abcde1!1 without a problem....
> I have been able to log into sql*plus with this password...
> BUT when I try to do:
>
> 1* alter user foxtest identified by foxtest1!1
> SQL> /
> alter user foxtest identified by foxtest1!1
> *
> ERROR at line 1:
> ORA-00922: missing or invalid option
>
> I get an error......
> Any idea????

<SNIP>

When posting it's always a good idea to post your version, patchset and OS type and version. It usually helps to get to timely and correct advice from the pro's.

However if you try

SQL>create user foxtest identified by "foxtest1!1";  you should find that it works. Not sure what the implications of using this password may be (in terms of using OLEDb etc), but it will let you create this password for the user and connect via SQLPlus (Once you have the nescessary grants etc)

HTH Spark Received on Thu Mar 04 2004 - 10:25:28 CST