Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: gui tool for oracle.. what is client when installation?
I would recommend them coming through ssh anyway, for security reasons. If they need a GUI tool, they can setup port forwarding/tunneling through ssh for X, so that they keep communicating with your box securely. Of course, you will need to block Oracle ports (1521 and 1526 usually) to prevent unauthorized parties from accessing your Oracle server, otherwise tunneling through ssh is of no use. You can do this in several ways - block ports on your firewall, put a tcp wrapper around Oracle listener or use listener's own filtering by adding
tcp.validnode_checking=yes
tcp.invited_nodes=(list of IPs that are allowed to connect, comma-separated)
into your sqlnet.ora or protocol.ora file in $ORACLE_HOME/network/admin and restarting listener.
-- Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications. All opinions are mine and do not necessarily go in line with those of my employer. "eugene kim" <eugene1977_at_hotmail.com> wrote in message news:alhkcr$v0f$1_at_newsreader.mailgate.org...Received on Mon Sep 09 2002 - 06:17:48 CDT
> forgot to ask one question,
> right now, my friends are using ssh to connect to my comp and sqlplus to
> connect to db.
>
> if i have set up tora(or 'oracle client'?)
> they wouldn't need ssh? ( just to see tables)
> and directly connect to my db?
> thank you