Re: How to Forbid sqlplus connecting to ORACLE

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Fri, 20 Jun 2003 00:12:44 +1000
Message-ID: <BdjIa.1101$nJ1.31303@newsfeeds.bigpond.com>

"Grant" <goddabao_at_yahoo.com> wrote in message news:bcp5la$gt_at_netnews.proxy.lucent.com...
> Hi,
>
> Does anyone know how to forbid sqlplus connecting to ORACLE Server?
> I don't want somebody using my DB Server via sqlplus in Client, and I will
> only permit the user using svrmgrl on the Host.
>
> The ORACLE Server version is 8.1.7 (another is 8.1.5), running on Solaris.
>
> Thanks
> Best Regards,
>

Hi Grant,

What you're after (I think) is the PRODUCT_USER_PROFILE table from which you can restrict which users perform what functions within SQL*PLUS. If you don't want anyone (other than DBAs of course) to do zip on the database from SQL*PLUS then it's a supported solution.

It's all documented in the SQL*PLUS manual (I would think).

Cheers

Richard Received on Thu Jun 19 2003 - 09:12:44 CDT