Copy Oracle User

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 DB name New User Password Existing user

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

Who is Participating?
slightwv (䄆 Netminder)Connect With a Mentor Commented:
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.
Geert GConnect With a Mentor Oracle dbaCommented:
toad has a script tab for the user
> replacing the username in that gives you an easy way to copy a user

if you trace what toad does ... you'd have the statements
sachin_dbaAuthor Commented:
I've requested that this question be deleted for the following reason:

Looks like this forum is not suitable for such queries.
slightwv (䄆 Netminder) Commented:
>>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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.