Re: Question - Standby databases: can I change passwords?

From: BD <bobby_dread_at_hotmail.com>
Date: 23 May 2006 10:47:41 -0700
Message-ID: <1148406461.054538.69000@38g2000cwa.googlegroups.com>

>How would an account set up on the standby database replicate to the
>production? By magic?

It wouldn't - but it would replicate _from_ production _to_ standby. Any ID that's established for use in reporting must exist in the production db first, right? Right?

>That would be a crap solution if you can set up an after-logon trigger easily.

Crap solution. Really...

Yes, logon triggers would be a good idea, if I were able to factor in v$session.username and v$session.osuser - also, I'd have to make sure that the trigger only executes if the ID is logged onto the primary db's server - the trigger would get propagated to the standby, where I want a more open environment.

Good suggestion - in spite of your 'crap' comment, which I could do without.

BD Received on Tue May 23 2006 - 12:47:41 CDT