Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: hosts.allow in net8/sqlnet
Well, in 8.1.6 use after logon trigger and SYS_CONTEXT('USERENV', 'IP_ADDRESS'). P.S. Under Windows NT protocol.ora setting for restrict ip not working.
john kelly <johnt.kelly_at_worldnet.att.net> wrote in message
news:Pine.WNT.4.30.0011212100280.254-100000_at_kellyspdc...
>
> Hi, Is it possible to wild card or use only a portion of a IP address to
> select a range of IP's?
>
> Thanks,
> John
>
> On Fri, 6 Oct 2000, Sybrand Bakker wrote:
>
> > On Thu, 05 Oct 2000 21:15:53 GMT, andreyNSPAM_at_bookexchange.net
> > (NetComrade ) wrote:
> >
> > >How do you implement restricting certain IPs to connect to the
> > >database?
> > >
> > >Thanx.
> >
> > You need to configure the file protocol.ora
> > This file should have
> > tcp.invited_nodes=(....)
> > tcp.excluded_nodes=(...)
> >
> > Hth
> >
> >
> > Sybrand Bakker, Oracle DBA
> >
>
Received on Tue Nov 21 2000 - 14:41:52 CST