From Jacques.Kilchoer@quest.com Fri, 11 May 2001 13:27:34 -0700 From: Jacques Kilchoer Date: Fri, 11 May 2001 13:27:34 -0700 Subject: RE: Password with special character Message-ID: MIME-Version: 1.0 Content-Type: text/plain Title: RE: Password with special character > -----Original Message----- > From: Sinardy Xing [mailto:sinardyxing@bcsis.com] > > I am using Oracle 8.1.6 Solaris 7 > Install patch bug1225555 for SQL*PLUS > > How can I change user password with special character >       alter user teddy identified by bear&12#$; > > is not working because of & > >       alter user teddy identified by 'bear&12#$'; > > also not working > > I have password_verification profile with verify_function > that provided by > Oracle Administrator Guide that must at least 1 special > character in user > password. Two things: a) the "&" is a special character for SQL*Plus, used for string substitution. b) Passwords, like database object names, must be surrounded by double quotes when they contain "special" characters. e.g. SQL> -- turn off "&" substitution SQL> set define off SQL> -- surround password by " for special char. SQL> alter user jrk identified by "bear&12#$" ; User altered. ------ Jacques R. Kilchoer (949) 754-8816 Quest Software, Inc. 8001 Irvine Center Drive Irvine, California 92618 U.S.A. http://www.quest.com