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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Limiting connection on product

Re: Limiting connection on product

From: <markp7832_at_my-deja.com>
Date: Mon, 13 Mar 2000 13:56:33 GMT
Message-ID: <8ais2e$pbf$1@nnrp1.deja.com>


In article <38CCD3A5.AC246D52_at_ni.ac.yu>,   Aleksandar Vasic <acko_at_ni.ac.yu> wrote:
> Hi everobody,
> I don't have much experience with database administration, so I have
> following problem:
> can I limit database conection from some client products, e.g.
> I want some oracle database user to be able to connect using forms
> but disable connection using SQL
> How can I do that?
> Thanks in advance...
>

I believe you can disable access to sqlplus using the Product_user_profile table. Look in the sqlplus manual and at pupbld.sql script in $ORACLE_HOME/sqlplus/admin/. --
Mark D. Powell -- The only advice that counts is the advice that  you follow so follow your own advice --

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Mar 13 2000 - 07:56:33 CST

Original text of this message

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