Re: Q: How to deny remote DBA access

"Vincent, Ip" <ar_pong_at_hotmail.com> wrote in news:9vmt2f$2e510_at_imsp212.netvigator.com:

> Hi all,
>
> I am now setting up an oracle server for my team.
> I want to configure the oracle server such that DBA remote connection
> through TCP/IP network is deny --> I want to deny something like "connect
> xx/xx as DBA" remotely.
>
> I am running Oracle 8i on Linux.
>
> I found some aritcles on the web mentioning it can be set in the
> "listener.ora" file. However, I could not found the exact syntax /
> procedures for such settings.
>
>
> Any clues?
>
> Thanks in advance.
>
> --
> Ah Pong
>
>
>
>
>

While a shovel may be a great tool for digging a hole, it works MUCH better when you use the correct end for the excavation.

You are trying to use the wrong end of Oracle.

Take a look at the initSID.ora parameters which control local & remote DB administration.

HTH & YMMV!
HAND Received on Wed Dec 19 2001 - 03:23:26 CET