Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Question - Standby databases: can I change passwords?
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.comReceived on Fri May 26 2006 - 14:09:34 CDT