Change username in DBA_USERS

From: Chirag DBA <chiragdba_at_gmail.com>
Date: Sat, 1 Oct 2005 11:59:40 -0400
Message-ID: <1a3629600510010859t5b55a5b1odffe73999b115061@mail.gmail.com>

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

--

http://www.freelists.org/webpage/oracle-l Received on Sat Oct 01 2005 - 11:01:39 CDT