RE: Password with special character (Thank You)
Thank you guys, Sinardy -Original Message- Sent: Friday, 11 May 2001 8:50 PM To: LazyDBA mailing list Hi Thye Hock Gan, Thank you for your info. I am using Oracle 8.1.6 Solaris 7 Install patch bug122 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. Thank you, Sinardy -Original Message- Sent: Friday, 11 May 2001 6:34 PM To: LazyDBA mailing list This are characters you can use: !"#$%&()'*+,-/:;<+>_ if I'm not mistaken. Try them anyway. --- Sinardy Xing <[EMAIL PROTECTED]> wrote: > Hi all, > > Can Oracle User change their password with special > characters? > > > Thank you very much > > > Sinady > > > Think you know someone who can answer the above > question? Forward it to them! > To unsubscribe: send a blank email to > [EMAIL PROTECTED] > To subscribe: send a blank email to > [EMAIL PROTECTED] > Visit the list archive: > http://www.LAZYDBA.com/odbareadmail.pl > Tell yer mates about http://www.farAwayJobs.com > __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ Think you know someone who can answer the above question? Forward it to them! To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com Think you know someone who can answer the above question? Forward it to them! To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Password with special character
Title: RE: Password with special character > -Original Message- > From: Sinardy Xing [mailto:[EMAIL PROTECTED]] > > I am using Oracle 8.1.6 Solaris 7 > Install patch bug122 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
Re: Password with special character
Sinardy Xing wrote: > Hi all, > > Can Oracle User change their password with special characters? As with other Oracle identifiers, you have to put double quotes around the password to include nonstandard stuff. SQL> ALTER USER SCOTT IDENTIFIED BY "*&^%$$# L"; User altered. SQL> CONNECT scott/"*&^%$$# L" Connected. Supposedly, lower case letters aren't supported in these passwords, but I've seen it work just fine. Incidentally, double quotes are not supported by the SQL*Plus "password" command, which is a shame. I've logged a TAR on this problem. Good luck Bill __ http://www.datacraft.com/http://plnet.org/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Pribyl INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Password with special character
If you're using the a profile with a password_verify function, then you shouldn't be using ALTER USER to change a user's password. If you are trying to change the password through SQL*Plus, then you should instead be using the SQL*Plus PASSWORD command: SQL> PASSWORD Using this command will validate the user's new password using the password_verify function that is specified in the user's profile, and will allow for the password to contain the special characters that you are trying to use. When you use ALTER USER it doesn't use that password_verify function, and because it is a DDL command, it limits you to Oracle's object naming restrictions, which will not allow you to use most special characters. For more information on this, see the Oracle8i Administrators Guide, pp 21-15 under "Password Complexity Verification", and also the SQL*Plus Users Guide and Reference Release 8.1.6, pp 8-76 for details on using the PASSWORD command. Both of these documents are available on Metalink. -::YEX::- <)))>< -Original Message- Sent: Friday, 11 May, 2001 10:01 AM To: Multiple recipients of list ORACLE-L Hi Thye Hock Gan, Thank you for your info. I am using Oracle 8.1.6 Solaris 7 Install patch bug122 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. Thank you, Sinardy -Original Message- Sent: Friday, 11 May 2001 6:34 PM To: LazyDBA mailing list This are characters you can use: !"#$%&()'*+,-/:;<+>_ if I'm not mistaken. Try them anyway. --- Sinardy Xing <[EMAIL PROTECTED]> wrote: > Hi all, > > Can Oracle User change their password with special > characters? > > > Thank you very much > > > Sinady > > > Think you know someone who can answer the above > question? Forward it to them! > To unsubscribe: send a blank email to > [EMAIL PROTECTED] > To subscribe: send a blank email to > [EMAIL PROTECTED] > Visit the list archive: > http://www.LAZYDBA.com/odbareadmail.pl > Tell yer mates about http://www.farAwayJobs.com > __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ Think you know someone who can answer the above question? Forward it to them! To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yexley Robert D SSgt AFIT/SCA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Password with special character
Hi Thye Hock Gan, Thank you for your info. I am using Oracle 8.1.6 Solaris 7 Install patch bug122 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. Thank you, Sinardy -Original Message- Sent: Friday, 11 May 2001 6:34 PM To: LazyDBA mailing list This are characters you can use: !"#$%&()'*+,-/:;<+>_ if I'm not mistaken. Try them anyway. --- Sinardy Xing <[EMAIL PROTECTED]> wrote: > Hi all, > > Can Oracle User change their password with special > characters? > > > Thank you very much > > > Sinady > > > Think you know someone who can answer the above > question? Forward it to them! > To unsubscribe: send a blank email to > [EMAIL PROTECTED] > To subscribe: send a blank email to > [EMAIL PROTECTED] > Visit the list archive: > http://www.LAZYDBA.com/odbareadmail.pl > Tell yer mates about http://www.farAwayJobs.com > __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ Think you know someone who can answer the above question? Forward it to them! To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
