Re: REPLICATING USERS..??

From: Connor McDonald <mcdonald.connor.cs_at_bhp.com.au>
Date: Wed, 03 Mar 1999 15:28:51 +0800
Message-ID: <36DCE4B3.854@bhp.com.au>

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..." Received on Wed Mar 03 1999 - 01:28:51 CST