[askdba] Fwd: Change username in DBA_USERS
- From: Chirag DBA <chiragdba@xxxxxxxxx>
- To: askdba@xxxxxxxxxxxxx
- Date: Sat, 1 Oct 2005 12:32:09 -0400
Hi,
I am changing the name of user in USER$ table.
SQL> select user#,name from user$ where name like 'SCO%';
USER# NAME
---------- ------------------------------
59 SCOTT
64 SCOTT1
SQL> update user$ set name='HERMESNEW' where user#=64;
1 row updated.
SQL> commit;
Commit complete.
SQL> select user#,name from user$ where name like 'SCO%';
USER# NAME
---------- ------------------------------
59 SCOTT
SQL> select user#,name from user$ where name like 'HER%';
USER# NAME
---------- ------------------------------
65 HERMES
64 HERMESNEW
SQL> alter user hermesnew identified by chirag;
User altered.
SQL> conn hermesnew/chirag
ERROR:
ORA-01017: invalid username/password; logon denied
Warning: You are no longer connected to ORACLE.
SQL> select username from dba_users;
SP2-0640: Not connected
SQL> conn / as sysdba
Connected.
SQL> select username from dba_users where username like 'HE%';
USERNAME
------------------------------
HERMES
This seems not to be permanent. Which view will help me to change it
permanently?
Regards -- Chirag
Other related posts:
- » [askdba] Fwd: Change username in DBA_USERS
