Re: 9iAS security?

From: Stephan van Hoof <test_at_test.nl>
Date: Mon, 20 Jan 2003 09:30:14 +0100
Message-ID: <1043051317.712711@newsreader2.wirehub.nl>

"Ban Spam" <ban-spam_at_operamail.com> wrote in message news:Xns93088E9CBE93ESunnySD_at_68.6.19.6...
> "Stephan" <test_at_test.com> wrote in
> news:KICW9.5$862.1453_at_nlnews00.chello.com:
>
> > Hi,
> >
> > We want to setup:
> > 2 W2000 machines: 1 with 9iAS and 1 with Oracle 9i database
> > Both behind firewall.
> >
> > Can someone point me to the right direction?:
> > - on the database: the listener.ora --> I only need simple access to
> > the database, so I can delete the EXTERNAL_PROCEDURE part?
>
> If you won't be running EX. PROCS, then remove those lines from
> listener.ora
>
> > - on the database: sqlnet.ora --> can I filter on IP --> to allow only
> > the 9iAS machine to connect (on port 1521?)
>
>
> This would preclude you or any DBA from connecting to the DB
> from their own PCs. Go ahead if that is acceptable

Ok, but imagine I want to connect from 2 PC's to the database and from the 9iAS machine : 3 IP's.
How do I set this in sqlnet.ora?

>
> > - on the 9iAS --> how to secure this machine? We want to run Forms
> > Server/Reports Server and JSP.
>
> 9iAS R1 or R2?
> RTFM
Release 2. (902) for winNT/2000 Received on Mon Jan 20 2003 - 02:30:14 CST