Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Question - Standby databases: can I change passwords?

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

From: JEDIDIAH <jedi_at_nomad.mishnet>
Date: Fri, 26 May 2006 14:09:34 -0500
Message-ID: <ec0kk3-9op.ln1@nomad.mishnet>


On 2006-05-23, Jagjeet Singh <jagjeet.malhi_at_gmail.com> wrote:
>
> SQL> select utl_inaddr.get_host_address from dual;
>
> GET_HOST_ADDRESS
> --------------------------------------------------------------------------------
> 10.249.66.249
>
> Setup logon trigger and check if ip of database server and it is the ip
> of productoin
> then raise error on login of that user.

        If it is a standby database you could also check the database role from v$database and have the logon trigger act accordingly based on that.

-- 
     Negligence will never equal intent, no matter how you 
attempt to distort reality to do so. This is what separates         |||
the real butchers from average Joes (or Fritzes) caught up in      / | \
events not in their control.

 Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------
    ** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------        
                http://www.usenet.com
Received on Fri May 26 2006 - 14:09:34 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US