SYS user's password problem..!!!
VJ4Apr 26 2010 — edited Apr 26 2010Hello ,
I got something new in oracle which surprises me !!!!!!!!!!!!!!!
step 1> I have open the command prompt of Windows XP. Then i typed .... sqlplus(enter)
d:>splplus
step 2> I have logged in as sys as sysdba with password sys.
usersname:sys as sysdba
password:sys
connected.
stept 3> I have changed the password of sys to dba.
SQL>Alter user sys identified by dba;
User Altered.
step 4> I logout of sqlplus
SQL>exit;
step 5> Now i repeat all the steps above and log in sys as sysdba with password sys.
Username:sys as sysdba
password:sys
Connected.
How does it take still the old password when i have altered it to the new password. ?????
I tried to login with the new password , then also it allows to do so ......why is this happening and what to do
*?????*
Thanks in advance .....