how to change user_name
hi all,
how to change the user name ,i tried this following way,
1* SELECT USER#,NAME FROM user$ WHERE NAME like upper('sad%')
SQL> /
USER# NAME
---------- ------------------------------
67 SADHA
SQL> update user$ set name='SADASIVAM' where user#='67';
1 row updated.
SQL> SELECT USER#,NAME FROM user$ WHERE NAME like upper('sad%');
USER# NAME
---------- ------------------------------
67 SADASIVAM
SQL> conn sadasivam/sadha@iportalorclsystem;
ERROR:
ORA-01017: invalid username/password; logon denied
plz any send the solution.