Re: Multi_master replication: Replicating USERS

Good to hear from you

> To do this for a 'standby' (not replicated) database, I have used a 'user
> creation' script that accepts the username and pwd from prompts and
> executes all the commands (create, alter, grant) against both databases.
> There are obvious limitations to this, not least of which is the need to
> check periodically for pwd updates that may have happened outside of
> program control and non-script user alterations. The check could be run
> externally (cron) or under dbms_jobs.
>
> Have you considered a trigger? A trigger could get around an
> 'immediately available' login requirement on the 2nd database, but I've
> not attempted to create a trigger of this nature. I'm also not positive
> if Oracle's encryption algorithm is the same from version to version,
> so I'd be sure the changes translated correctly if I had multiple versions!

I dont think you are allowed to create a trigger on a SYS table. After thinking about it, I have decided to use Oracle's own replicate DDL command procedure to do it. It is similar to replicating all DDL for a given schema.

Thanks for your idea.

ta
tony

--

 _____       ________ / ___|Tony Jambu, Database Consultant
  /_  _        /_ __ /     |Wizard Consulting,Aust (ACN 065934778)
 /(_)/ )(_/ \_/(///(/_)/_( |CIS: 100250.2003_at_compuserve.com FAX: +61-3-4163559
 \_______/                 |EMAIL:TJambu_at_wizard.com.au PHONE: +61-3-4122905