Solved

Copy Oracle User

Posted on 2014-01-30
6
512 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
  • 2
6 Comments
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 250 total points
Comment Utility
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 36

Assisted Solution

by:Geert Gruwez
Geert Gruwez earned 250 total points
Comment Utility
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
Comment Utility
I've requested that this question be deleted for the following reason:

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

Expert Comment

by:slightwv (䄆 Netminder)
Comment Utility
>>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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
one-way data "masking" MD5 sql 26 95
Oracle TEXT search question 9 26
EXECUTE IMMEDIATE 5 33
Oracle Next Available Number 2 11
How to remove superseded packages in windows w60 or w61 installation media (.wim) or online system to prevent unnecessary space. w60 means Windows Vista or Windows Server 2008. w61 means Windows 7 or Windows Server 2008 R2. There are various …
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
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.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

772 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now