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-02 - By Sunil Bhola

Reply: << 11

Hi Chirag,

I have did the same as you did, but mine is working.. I think there is some
problem with your end...

Here is the case study :

SQL> select name from v$database;
NAME
-- ---- ---- ---- ---- ----
VED
SQL> select user#,name from user$ where name like 'SCO%';
USER#
-- ---- --
NAME
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
59
SCOTT

SQL> update user$ set name='HERMESNEW' where user#=64;
0 rows updated.
SQL> updated user$ set name='SUNIL' where user#=59;
SP2-0734: unknown command beginning "updated us..." - rest of line ignored.
SQL> update user$ set name='SUNIL' where user#=59;
1 row updated.
SQL> commit;
Commit complete.
SQL> select user#,name from user$ where name like 'HER%';
no rows selected
SQL> ed
Wrote file afiedt.buf
1* select user#,name from user$ where name like 'SUN%'
SQL> /
USER#
-- ---- --
NAME
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
59
SUNIL

SQL> alter user sunil identified by sunil;
User altered.
SQL> connect sunil/sunil
Connected.
SQL>

QUERIES in Oracle, Feel free to Join:

http://groups.yahoo.com/group/oracle_expert/

Regards,

Sunil Bhola

Oracle_Expert, Moderator

Chirag DBA <chiragdba@(protected)> wrote:
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

-- ---- ---- ---- ---- ---- -----
Yahoo! for Good
Click here to donate to the Hurricane Katrina relief effort.
<DIV>Hi Chirag,</DIV>
<DIV> </DIV>
<DIV>I have did the same as you did, but mine is working.. I think there is
some problem with your end... </DIV>
<DIV> </DIV>
<DIV>Here is the case study :</DIV>
<DIV> </DIV>
<DIV>SQL> select name from v$database;</DIV>
<DIV>NAME<BR>-- ---- ---- ---- ---- ----<BR>VED</DIV>
<DIV>SQL> select user#,name from user$ where name like 'SCO%';</DIV>
<DIV>     USER#<BR>-- ---- --<BR>NAME<BR>-- ---- ---- -----
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ----<BR>  
      59<BR>SCOTT</DIV>
<DIV><BR>SQL> update user$ set name='HERMESNEW' where user#=64;</DIV>
<DIV>0 rows updated.</DIV>
<DIV>SQL> updated user$ set name='SUNIL' where user#=59;<BR>SP2-0734:
unknown command beginning "updated us..." - rest of line ignored.<BR>SQL>
update user$ set name='SUNIL' where user#=59;</DIV>
<DIV>1 row updated.</DIV>
<DIV>SQL> commit;</DIV>
<DIV>Commit complete.</DIV>
<DIV>SQL> select user#,name from user$ where name like 'HER%';</DIV>
<DIV>no rows selected</DIV>
<DIV>SQL> ed<BR>Wrote file afiedt.buf</DIV>
<DIV>  1* select user#,name from user$ where name like 'SUN%'<BR>SQL> /
</DIV>
<DIV>     USER#<BR>-- ---- --<BR>NAME<BR>-- ---- ---- -----
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ----<BR>  
      59<BR>SUNIL</DIV>
<DIV><BR>SQL> alter user sunil identified by sunil;</DIV>
<DIV>User altered.</DIV>
<DIV>SQL> connect sunil/sunil<BR>Connected.<BR>SQL> </DIV>
<DIV> </DIV>
<DIV>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><STRONG><B><FONT face=Verdana
color=#434343 size=3><SPAN style="FONT-SIZE: 12pt; COLOR: #434343; FONT-FAMILY:
Verdana">QUERIES in Oracle, Feel free to Join:</SPAN></FONT></B></STRONG><?xml
:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o
:p></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><STRONG><B><FONT face=Verdana
size=3><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Verdana"><A href="http:/
/groups.yahoo.com/group/oracle_expert/"><FONT color=#434343><SPAN style="COLOR:
#434343">http://groups.yahoo.com/group/oracle_expert/</SPAN></FONT></A><FONT
color=yellow><SPAN style="COLOR: yellow"> </SPAN></FONT></SPAN></FONT></B><
/STRONG><o:p></o:p></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><STRONG><B><FONT face=Verdana
size=3><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Verdana">Regards,</SPAN><
/FONT></B></STRONG><o:p></o:p></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><STRONG><B><FONT face=Verdana
color=red><SPAN style="FONT-SIZE: 12pt; COLOR: red; FONT-FAMILY: Verdana">S<
/SPAN></FONT></B></STRONG><STRONG><B><FONT face=Verdana size=3><SPAN style="FONT
-FAMILY: Verdana">unil <FONT color=red><SPAN style="COLOR: red">B</SPAN></FONT
>hola</SPAN></FONT></B></STRONG><o:p></o:p></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><STRONG><B><FONT face=Verdana>
<SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Verdana">Oracle_Expert, Moderator<
/SPAN></FONT></B></STRONG><o:p></o:p></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT face=Arial color=navy size
=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"><o:p> </o
:p></SPAN></FONT></P><BR><BR><B><I>Chirag DBA <chiragdba@(protected)></I></B
> wrote:</DIV>
<BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER
-LEFT: #1010ff 2px solid">
<DIV>Hi,</DIV>
<DIV> </DIV>
<DIV>I am changing the name of user in USER$ table.</DIV>
<DIV>
<P>SQL> select user#,name from user$ where name like 'SCO%';</P>
<P>     USER# NAME<BR>-- ---- -- -- ---- ---- ---- ---- ---
----<BR>        59 SCOTT<BR>  &nbsp
;     64 SCOTT1</P></DIV>
<DIV>
<P>SQL> update user$ set name='HERMESNEW' where user#=64;</P>
<P>1 row updated.</P>
<P>SQL> commit;</P>
<P>Commit complete.</P>
<P>SQL> select user#,name from user$ where name like 'SCO%';</P>
<P>     USER# NAME<BR>-- ---- -- -- ---- ---- ---- ---- ---
----<BR>        59 SCOTT</P>
<P>SQL> select user#,name from user$ where name like 'HER%';</P>
<P>     USER# NAME<BR>-- ---- -- -- ---- ---- ---- ---- ---
----<BR>        65 HERMES<BR>  
      64 HERMESNEW<BR></P>
<P>SQL> alter user hermesnew identified by chirag;</P>
<P>User altered.</P>
<P>SQL> conn hermesnew/chirag<BR>ERROR:<BR>ORA-01017 (See ORA-01017.ora-code.com): invalid username
/password; logon denied</P>
<P><BR>Warning: You are no longer connected to ORACLE.<BR>SQL> select
username from dba_users;<BR>SP2-0640: Not connected<BR>SQL> conn / as sysdba
<BR>Connected.</P>
<P>SQL> select username from dba_users where username like 'HE%';</P>
<P>USERNAME<BR>-- ---- ---- ---- ---- ---- --<BR>HERMES</P>
<P> </P>
<P>This seems not to be permanent. Which view will help me to change it
permanently?</P>
<P> </P>
<P>Regards  --  Chirag </P></DIV></BLOCKQUOTE><p>
<hr size=1>Yahoo! for Good<br>
<a href="http://store.yahoo.com/redcross-donate3/">Click here to donate</a> to
the Hurricane Katrina relief effort.