Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2005
    Posts
    39

    Unanswered: creating oracle user as that of existing user

    Hello All,

    I have two machines on which oracle is running....on one machine... one user is their.....I need to create same type of oracle user on other machine....!!!

    How should i go for this...?? so that new user (on one machine) has the same priviledge and grants(everything) as that of existing user on other machine.

    Any help will be highly appreciated ...!!!

    Thanking in anticipation.

    Regards,
    Rajeev Tomar

  2. #2
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    You can find a suitable script to help you do this here:

    http://www.orafaq.com/scripts/sql/cre8like.txt
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  3. #3
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    How about using EXP(ort) and IMP(ort) utilities? If you need the whole schema (that is, user and its tables, views, grants, triggers, ...), perhaps you could consider this too.

    By the way, if you will use Frank's script, don't forget to SPOOL output into some file (because running it as it is will not do anything) and run it on another database.

Posting Permissions

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