Change username in DBA_USERS 2005-10-01 - By Chirag DBA
I am unable to find the page you are looking of TOM Kyte. Can u send me the
URL?
I was trying cause I knew someone has done this in past. just forgot the
"HOW" portion.
Now the question is what will be the affect of doing this. I didn even find
anythinng about this in trace file.
Is this the simple update for Oracle like any other schema. No way.
Regards - Chirag
On 10/1/05, Radoulov, Dimitre <cichomitiko@(protected)> wrote:
>
> There should be a reason for Tom Kyte's answer :O)
> <quote>
>
> I'm surprised Tom let the one about updating the sys.user$ table slip by
without
> any chiding. Wouldn't that be a strict no-no anyways?
>
> Kashif
>
>
> *Followup:*
>
> that would be strictly a no-no -- 100%
>
> </quote>
> HI,
> Dimitre
>
> -- -- Original Message -- --
> *From:* Chirag DBA <chiragdba@(protected)>
> *To:* David Sharples <davidsharples@(protected)>
> *Cc:* Radoulov, Dimitre <cichomitiko@(protected)> ; Oracle-L Freelists<oracle-l
@(protected)>; Ganesh
> Raja <ganesh.raja@(protected)>
> *Sent:* Saturday, October 01, 2005 7:00 PM
> *Subject:* Re: Change username in DBA_USERS
>
> D O N E ..... ! ! ! ! !
> was thinking of changing the ownership column first.
> But see, this works, with not a single error or warning in TRACE file.
>
> SQL> select user#,name from user$ where name like 'SCOT%';
>
> USER# NAME
> -- ---- -- -- ---- ---- ---- ---- ---- --
> 59 SCOTT
> 64 SCOTT1
>
> SQL> update user$ set name='HERMESNEW' where user#=64;
>
> 1 row updated.
>
> SQL> commit;
>
> Commit complete.
>
> SQL> shutdown immediate;
> Database closed.
> Database dismounted.
> ORACLE instance shut down.
> SQL> startup
> ORACLE instance started.
>
> Total System Global Area 105978600 bytes
> Fixed Size 453352 bytes
> Variable Size 79691776 bytes
> Database Buffers 25165824 bytes
> Redo Buffers 667648 bytes
> Database mounted.
> Database opened.
> SQL> select user#,name from user$ where name like 'SCOT%';
>
> USER# NAME
> -- ---- -- -- ---- ---- ---- ---- ---- --
> 59 SCOTT
>
> SQL> select user#,name from user$ where name like 'HER%';
>
> USER# NAME
> -- ---- -- -- ---- ---- ---- ---- ---- --
> 65 HERMES
> 64 HERMESNEW
>
> SQL> select username from dba_users where username like 'HER%';
>
> USERNAME
> -- ---- ---- ---- ---- ---- --
> HERMES
> HERMESNEW
>
> SQL> alter user hermesnew identified by chirag;
>
> User altered.
>
> SQL> conn hermesnew/chirag
> Connected.
> SQL> select * from tab;
>
> TNAME TABTYPE CLUSTERID
> -- ---- ---- ---- ---- ---- -- -- ---- -- ---- --
> BONUS TABLE
> CHIRAG TABLE
> DEPT TABLE
> EMP TABLE
> SALGRADE TABLE
> TEMP1 TABLE
>
> 6 rows selected.
>
> SQL> sho user
> USER is "HERMESNEW"
> SQL>
>
> Thanx to everyone....
>
> Regards - Chirag
> On 10/1/05, Chirag DBA <chiragdba@(protected)> wrote:
> >
> > hmmmm...!!!
> > Its a large dump, takes more than 5 hrs. so thinking to get it in
> > "SHORT WAY".
> > Export problem was because of replicated objects.
> > can afford to have a corruption on my local test database.
> >
> > regards - chirag
> > On 10/1/05, David Sharples <davidsharples@(protected) > wrote:
> > >
> > > simple, dont do it, not supported, doesnt work and corrupts the data
> > > dictionary and oracle support would tell you to go away.
> > > Any good person will tell you to stop right now and do it the proper
> > > way
> > > Fromuser / touser export is the only way of doing it, so fix your
> > > export problems.
> > >
> > >
> > > On 10/1/05, Chirag DBA <chiragdba@(protected) > wrote:
> > > >
> > > > Its not a joke and am doing this on test.
> > > > I remember one incident on LAZYDBAs , where a DBA did programming
> > > > on USER_ID and then required to change the USER_ID. He did it someway,
but I
> > > > am unable to recollect.
> > > > There must be the way we can do. ( I think so).
> > > >
> > >
> >
>
<div>I am unable to find the page you are looking of TOM Kyte. Can u send me
the URL?</div>
<div> </div>
<div>I was trying cause I knew someone has done this in past. just forgot the
"HOW" portion.</div>
<div> </div>
<div>Now the question is what will be the affect of doing this. I didn even
find anythinng about this in trace file.</div>
<div> </div>
<div>Is this the simple update for Oracle like any other schema. No
way.</div>
<div> </div>
<div>Regards - Chirag <br><br> </div>
<div><span class="gmail_quote">On 10/1/05, <b class="gmail_sendername">Radoulov
, Dimitre</b> <<a href="mailto:cichomitiko@(protected)">cichomitiko@(protected)<
/a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0
.8ex; BORDER-LEFT: #ccc 1px solid">
<div><font face="Arial" size="2">There should be a reason for Tom Kyte's answer
:O)</font></div>
<div><font face="Arial" size="2"></font> </div>
<div><font face="Arial" size="2"></font> </div>
<div><font face="Arial" size="2"><quote></font></div>
<div><pre>I'm surprised Tom let the one about updating the sys.user$ table slip
by without
any chiding. Wouldn't that be a strict no-no anyways?
Kashif
</pre><br>
<table cellspacing="2" cellpadding="2">
<tbody>
<tr>
<td valign="top" align="left" width="5%"><font face="verdana,arial,helvetica"
size="-1"><b>Followup:<a name="106ad27b59cc082a_30559094142224"></a></b> </font
></td></tr>
<tr>
<td width="95%"><pre>that would be strictly a no-no -- 100% </pre></td></tr><
/tbody></table></div>
<div><font face="Arial" size="2"></quote></font></div>
<div> </div>
<div> </div>
<div><font face="Arial" size="2">HI,</font><br>Dimitre </div>
<div> </div>
<div> </div>
<blockquote style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px;
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px"><span class="q">
<div style="FONT: 10pt arial">-- -- Original Message -- -- </div>
<div style="BACKGROUND: #e4e4e4; FONT: 10pt arial"><b>From:</b> <a title=
"chiragdba@(protected)" onclick="return top.js.OpenExtLink(window,event,this)"
href="mailto:chiragdba@(protected)" target="_blank">Chirag DBA</a> </div>
<div style="FONT: 10pt arial"><b>To:</b> <a title="davidsharples@(protected)"
onclick="return top.js.OpenExtLink(window,event,this)" href="mailto
:davidsharples@(protected)" target="_blank">David Sharples</a> </div>
<div style="FONT: 10pt arial"><b>Cc:</b> <a title="cichomitiko@(protected)"
onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:cichomitiko
@(protected)" target="_blank">Radoulov, Dimitre</a> ; <a title="oracle-l@(protected)
.org" onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:oracle
-l@(protected)" target="_blank">
Oracle-L Freelists</a> ; <a title="ganesh.raja@(protected)" onclick="return top
.js.OpenExtLink(window,event,this)" href="mailto:ganesh.raja@(protected)" target="
_blank">Ganesh Raja</a> </div></span><span class="q">
<div style="FONT: 10pt arial"><b>Sent:</b> Saturday, October 01, 2005 7:00 PM<
/div>
<div style="FONT: 10pt arial"><b>Subject:</b> Re: Change username in DBA_USERS<
/div>
<div><br> </div></span>
<div><span class="e" id="q_106ad27b59cc082a_3">
<div>D O N E ..... ! ! ! ! ! </div>
<div><font face="Arial" size="2"></font> </div>
<div>was thinking of changing the ownership column first. </div>
<div>But see, this works, with not a single error or warning in TRACE file.<
/div>
<div>
<p>SQL> select user#,name from user$ where name like 'SCOT%';</p>
<p> USER# NAME<br>-- ---- -- -- ---- ---- ---- ---- ---
----<br> 59 SCOTT<br>  
; 64 SCOTT1</p>
<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> shutdown immediate;<br>Database closed.<br>Database dismounted.<br
>ORACLE instance shut down.<br>SQL> startup<br>ORACLE instance started.</p>
<p>Total System Global Area 105978600 bytes<br>Fixed Size
453352 bytes<br>Variable Size
79691776 bytes<br>Database
Buffers 25165824
bytes<br>Redo Buffers
667648 bytes
<br>Database mounted.<br>Database opened.<br>SQL> select user#,name from
user$ where name like 'SCOT%';</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</p>
<p>SQL> select username from dba_users where username like 'HER%';</p>
<p>USERNAME<br>-- ---- ---- ---- ---- ---- --<br>HERMES<br>HERMESNEW</p>
<p>SQL> alter user hermesnew identified by chirag;</p>
<p>User altered.</p>
<p>SQL> conn hermesnew/chirag<br>Connected.<br>SQL> select * from tab;</p>
<p>TNAME  
;
TABTYPE CLUSTERID<br>-- ---- ---- ---- ---- ---- -- -- ---- -- ---- --<br
>BONUS
TABLE<br>CHIRAG
TABLE<br>DEPT
TABLE
<br>EMP
TABLE<br>SALGRADE
TABLE<br>TEMP1  
;
TABLE</p>
<p>6 rows selected.</p>
<p>SQL> sho user<br>USER is "HERMESNEW"<br>SQL></p>
<p>Thanx to everyone....</p>
<p>Regards - Chirag<br></p></div>
<div><span class="gmail_quote">On 10/1/05, <b class="gmail_sendername">Chirag
DBA</b> <<a onclick="return top.js.OpenExtLink(window,event,this)" href=
"mailto:chiragdba@(protected)" target="_blank">chiragdba@(protected)</a>
> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0
.8ex; BORDER-LEFT: #ccc 1px solid">
<div>hmmmm...!!! </div>
<div> </div>
<div>Its a large dump, takes more than 5 hrs. so thinking to get it in "
;SHORT WAY".</div>
<div> </div>
<div>Export problem was because of replicated objects.</div>
<div> </div>
<div>can afford to have a corruption on my local test database.<br><br>regards
- chirag </div>
<div><span>
<div> </div>
<div><span class="gmail_quote">On 10/1/05, <b class="gmail_sendername">David
Sharples</b> <<a onclick="return top.js.OpenExtLink(window,event,this)" href
="mailto:davidsharples@(protected)" target="_blank">davidsharples@(protected)
</a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0
.8ex; BORDER-LEFT: #ccc 1px solid">
<div>simple, dont do it, not supported, doesnt work and corrupts the data
dictionary and oracle support would tell you to go away.</div>
<div> </div>
<div>
<div>Any good person will tell you to stop right now and do it the proper way<
/div>
<div> </div></div>
<div>Fromuser / touser export is the only way of doing it, so fix your export
problems.</div>
<div><span>
<div><br><br> </div>
<div><span class="gmail_quote">On 10/1/05, <b class="gmail_sendername">Chirag
DBA</b> <<a onclick="return top.js.OpenExtLink(window,event,this)" href=
"mailto:chiragdba@(protected)" target="_blank">chiragdba@(protected)</a>
> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0
.8ex; BORDER-LEFT: #ccc 1px solid">
<div>Its not a joke and am doing this on test.</div>
<div> </div>
<div>I remember one incident on LAZYDBAs , where a DBA did programming on USER
_ID and then required to change the USER_ID. He did it someway, but I am unable
to recollect.</div>
<div> </div>
<div>There must be the way we can do. ( I think so).</div></blockquote></div><
/span></div></blockquote></div><br></span></div></blockquote></div><br></span><
/div></blockquote></blockquote></div><br>
|
|
