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
