Re: How to use _at_ in oracle user password
Date: Mon, 12 Nov 2001 10:31:40 +0100
Message-ID: <9so4th$eivi$1_at_as201.hinet.hr>
> We use a tool to generate most passwords, and one password which was
> generated contained an _at_ symbol. The oracle user password was set...
> but how can a user connect when there is an _at_ in the password:
>
> $ sqlplus user/p_at_ssword_at_tnsname
>
> (I know there are security issues with using the password on the
> command line, but ignore those for now...) The results in oracle
> thinking the password is simply 'p'. and an error of:
>
> ORA-12154: TNS:could not resolve service name
>
> I tried to escape it various ways, but didn't come up with a solution.
> We have since changed the password, but Im curious if there is a
> solution to this...
>
> Many thanks in advance...
This looks like a joke I heard.
Men goes to hospital and says: Doctor, my arm hurts when I do this. Doctor: Well, don't do it. Received on Mon Nov 12 2001 - 10:31:40 CET