RE: Password with special character

From: Yexley Robert D SSgt AFIT/SCA <Robert.Yexley_at_afit.edu>
Date: Fri, 11 May 2001 11:46:54 -0700
Message-ID: <F001.00300EC4.20010511074114@fatcity.com>

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 <username>

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 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.

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 <sinardyxing_at_bcsis.com> 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
  > oracledba-unsubscribe_at_LAZYDBA.com
  > To subscribe: send a blank email to
  > oracledba-subscribe_at_LAZYDBA.com
  > 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 oracledba-unsubscribe_at_LAZYDBA.com To subscribe: send a blank email to oracledba-subscribe_at_LAZYDBA.com 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: sinardyxing_at_bcsis.com

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: ListGuru_at_fatcity.com (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: Robert.Yexley_at_afit.edu

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: ListGuru_at_fatcity.com (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).

Received on Fri May 11 2001 - 13:46:54 CDT