Re: REPLICATING USERS..??

From: Peter Sharman <psharman_at_us.oracle.com>
Date: Wed, 03 Mar 1999 09:11:33 -0800
Message-ID: <36DD6D45.E95C84C3@us.oracle.com>

An easier approach would be to use Enterprise Manager to do all the work, recording it to a file, then schedule the job against multiple databases using the job scheduler.

HTH Pete

Connor McDonald wrote:

> Chittesh Mehta wrote:
> >
> > Hi,
> >
> > Is there any way from Oracle that we can replicate users between two
> > database servers ?
> >
> > I mean, If we create User X on one server should be created with the same
> > properties on server B?
> >
> > Any idea on this will be highly appriciated..
> >
> > Thanks
> >
> > - Chittesh
> > chittesh_at_swi.com.sg
>
> I haven't done it but the advanced replication option in Oracle offers
> the ability to replicate DDL thus your "create user", "grant create
> session" etc etc would be sent around to multiple environments...
>
> HTH
> --
> ==============================================
> Connor McDonald
> BHP Information Technology
> Perth, Western Australia
> "Never wrestle a pig - you both get dirty and the pig likes it..."

Regards

Pete

Peter Sharman                              Email: psharman_at_us.oracle.com
WISE Course Development Manager            Phone: +1.650.607.0109 (int'l)
Worldwide Internal Services Education               (650)607 0109 (local)

San Francisco

"Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook
"Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA

Received on Wed Mar 03 1999 - 11:11:33 CST