Change username in DBA

Links

Frequent Oracle Errors

•	TNS:could not resolve the connect identifier specified
•	Backtrace message unwound by exceptions
•	invalid identifier
•	PL/SQL compilation error
•	internal error
•	missing expression
•	table or view does not exist
•	end-of-file on communication channel
•	TNS:listener unknown in connect descriptor
•	insufficient privileges
•	PL/SQL: numeric or value error string
•	TNS:protocol adapter error
•	ORACLE not available
•	target host or object does not exist
•	invalid number
•	unable to allocate string bytes of shared memory
•	resource busy and acquire with NOWAIT specified
•	error occurred at recursive SQL level string
•	ORACLE initialization or shutdown in progress
•	archiver error. Connect internal only, until freed
•	snapshot too old
•	unable to extend temp segment by string in tablespace
•	Credential retrieval failed
•	missing or invalid option
•	invalid username/password; logon denied
•	unable to create INITIAL extent for segment
•	out of process memory when trying to allocate string bytes
•	shared memory realm does not exist
•	cannot insert NULL
•	TNS:unable to connect to destination
•	remote database not found'>ora-02019
•	exception encountered: core dump
•	inconsistent datatypes
•	no data found
•	TNS:operation timed out
•	PL/SQL: could not find program
•	existing state of packages has been discarded
•	maximum number of processes exceeded
•	error signaled in parallel query server
•	ORACLE instance terminated. Disconnection forced
•	TNS:packet writer failure
•	see ORA-12699
•	missing right parenthesis
•	name is already used by an existing object
•	cannot identify/lock data file
•	invalid file operation
•	quoted string not properly terminated

Change username in DBA_USERS

Change username in DBA_USERS

2005-10-01 - By Chirag DBA

Reply: 1 2 3 4 5 6 7 8 9 10 >>

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 (See ORA-01017.ora-code.com): 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

<div>Hi,</div>
<div> </div>
<div>I am changing the name of user in USER$ table.</div>
<div>
SQL> select user#,name from user$ where name like 'SCO%';
     USER# NAME -- ---- -- -- ---- ---- ---- ---- ---
----         59 SCOTT   &nbsp
;     64 SCOTT1</div>
<div>
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 (See ORA-01017.ora-code.com): 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 </div>