Re: Preventing SQLPLUS access?

From: Jurij Modic <jurij.modic_at_mf.sigov.mail.si>
Date: 1997/06/06
Message-ID: <33988256.15429792@www.sigov.si>#1/1

On Fri, 6 Jun 1997 18:23:56 GMT, skubiszewski_at_Eisner.DECUS.Org wrote:

>We have a large user base using a custom-written client-server application
>with Oracle as the database. Our developers are worried that crafty users
>will discover that they can use their application signon to come in via
>SQLPLUS. We don't want anyone manipulating the database from outside
>the custom application.
>
>Is there an easy way to prevent this from happening?

Yes. Use SYSTEM.PRODUCT_USER_PROFILE table to restrict privileges of certain user within certain product (SQL*Plus included). If you don't have this table in SYSTEM's shema yet, create it with pupbld.sql, located somewhere under $ORACLE_HOME.

Look in Oracle documentation (try in SQL*Plus guide) for more information about table's usage.

Regards,

Jurij Modic                             Republic of Slovenia
tel: +386 61 178 55 14                  Ministry of Finance
fax: +386 61  21 45 84                  Zupanciceva 3

e-mail: jurij.modic_at_mf.sigov.mail.si Ljubljana 1000

Received on Fri Jun 06 1997 - 00:00:00 CDT