Re: Change username in DBA_USERS

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_at_gmail.com> 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_at_gmail.com>
> *To:* David Sharples <davidsharples_at_gmail.com>
> *Cc:* Radoulov, Dimitre <cichomitiko_at_gmail.com> ; Oracle-L Freelists<oracle-l_at_freelists.org>; Ganesh
> Raja <ganesh.raja_at_gmail.com>
> *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_at_gmail.com> 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_at_gmail.com > 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_at_gmail.com > 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).
> > > >
> > >
> >
>

--
http://www.freelists.org/webpage/oracle-l