Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to Forbid sqlplus connecting to ORACLE

Re: How to Forbid sqlplus connecting to ORACLE

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Thu, 19 Jun 2003 20:47:59 +0100
Message-ID: <3ef21316$0$960$cc9e4d1f@news.dial.pipex.com>


"Richard Foote" <richard.foote_at_bigpond.com> wrote in message news:BdjIa.1101$nJ1.31303_at_newsfeeds.bigpond.com...
> 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).

Could you mean this

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a90842/ch10.htm#1005596

I've been trying to avoid RTFM....

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
Received on Thu Jun 19 2003 - 14:47:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US