Solved

Copy Oracle User

Posted on 2014-01-30
6
522 Views
Last Modified: 2014-03-12
Dear DBAs

Could you please help me to write a Shell or sql scripts (parameterized) for following.

Copy_user("DB name","New User","Password","Existing user");

Shell copy_users.sh DB name New User Password Existing user

DB name: For additional check to confirm that we are running in correct DB.

Thanks
0
Comment
Question by:sachin_dba
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
6 Comments
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 250 total points
ID: 39820610
Sorry but there really isn't an 'easy' way to do this.  There are a lot of steps involved.

If you Google around for oracle clone user, you can find some scripts people have out there.

I doubt you'll find anyone here that will write one for you.

If you have specific questions about something, we can help with that.
0
 
LVL 37

Assisted Solution

by:Geert Gruwez
Geert Gruwez earned 250 total points
ID: 39823319
toad has a script tab for the user
> replacing the username in that gives you an easy way to copy a user

http://www.quest.com/toad-for-oracle/

if you trace what toad does ... you'd have the statements
0
 

Author Comment

by:sachin_dba
ID: 39913811
I've requested that this question be deleted for the following reason:

Looks like this forum is not suitable for such queries.
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 39913812
>>Looks like this forum is not suitable for such queries.

If you were here to get someone to write all the code for you then I agree.

If you were here to figure out how to do this, then I have to disagree.

Short of writing the code, I believe we answered the question as well as we could.

If you needed additional information you should have asked.
0

Featured Post

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
Recently, an awarded photographer, Selina De Maeyer (http://www.selinademaeyer.com/), completed a photo shoot of a beautiful event (http://www.sintjacobantwerpen.be/verslag-en-fotoreportage-van-de-sacramentsprocessie-door-antwerpen#thumbnails) in An…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
Via a live example, show how to take different types of Oracle backups using RMAN.

729 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question