DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Change the user name

  1. #1
    Join Date
    Jun 2002
    Posts
    8

    Question

    Hi,

    I want to change my user name in database.Is it possible to change user name without affecting all objects in that user? Can anyone give solution for this?

    Thx,
    Selva

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    I don't think it's possible to change a username, the easiest way to acomplish this is to take an export of the current user, create a new user and then import the schema into the new user.

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  3. #3
    Join Date
    May 2002
    Location
    USA
    Posts
    462
    or the round about is create another user and grant this user all the privileges . might be much faster than export and inport .
    siva prakash
    DBA

  4. #4
    Join Date
    Aug 2002
    Location
    Bangalore, India
    Posts
    405
    Or you can update the USER$ table. But, your datadictionary will be currupted, you may not be able to do few datadictionary related activities there after :d
    -nagarjuna

  5. #5
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    Originally posted by nagarjuna
    Or you can update the USER$ table. But, your datadictionary will be currupted, you may not be able to do few datadictionary related activities there after :d
    When oracle corp strongly advises you to keep away from these tables, why in the hell would anyone go there??

    And what's such a big deal of changing a users name when you have managed him thru a role?
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width