Re: User Cloning

Hi Tim,

Thanks for writing me the solution. Yes, I am using oracle enterprise manager but looking for some script kind of solution because I have to give this solution to developers so that they should be able to refresh there data/login from main login having clean fresh and data.

Tim McConechy wrote:

> 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 Tue Nov 04 1997 - 00:00:00 CST