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