FreeLists / oracle-l / Re: Change username in DBA_USERS

["Radoulov, Dimitre" <cichomitiko@xxxxxxxxx>]

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 
  To: David Sharples 
  Cc: Radoulov, Dimitre ; Oracle-L Freelists ; Ganesh Raja 
  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@xxxxxxxxx> 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@xxxxxxxxx > 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@xxxxxxxxx > 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).