Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to Forbid sqlplus connecting to ORACLE
"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