Re: User Cloning

From: Tim McConechy <tmcconec_at_wie.com>
Date: 1997/11/03
Message-ID: <345E73B2.1E89C1A5@wie.com>#1/1

Mahesh Anand wrote:

> Hi Guys,
>
> I need to clone a user to other user how can I do that. I mean clone is
> I want to copy all objects, relations data belongs to one user to be
> copied to other user. does anyone have such kind script or is there any
> facility in oracle to clone user. I am using 7.3.3 on NT

Hello! Have you tried using Oracle Enterprise Manager!

Mine runs under 8.0.3 and 7.3.3 and allows me to "Create Like" (Installed with Oracle 8) But our Older NT Databases have it Too!
Check your CD's

Launch Security Manager in the Enterprise Manager program Group.

With the user you want to "clone" highlighted

Go to User / Create Like.
(Use Show SQL if you want to See the code!)

Works Great! (Only problem is the two users do not remain syncronized) i.e. on adds a table the other doesn't know about unlessthey communicate!

I'm sure there are scripts too.
Try
http://www.oramg.com and search? for some code snipets I have found quite a few good ones here over the days!

Good Luck Received on Mon Nov 03 1997 - 00:00:00 CST