Hi all,
Can Oracle User change their password with special characters?
Thank you very much
Sinady
--
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,
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 bear12#$;
is not working because of
alter user teddy identified by 'bear12
Solaris 7
Install patch bug122 for SQL*PLUS
How can I change user password with special character
alter user teddy identified by bear12#$;
is not working because of
alter user teddy identified by 'bear12#$';
also not working
I have password_verification profile
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/*^%$$#
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 bear12