Re: Preventing SQLPLUS access?

In article <EBD9rw.28L_at_news.decus.org>,
  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?

Try using PRODUCT_USER_PROFILE, see Appendix E of the SQLPlus user's guide. Also, consider having roles dynamically enabled within the application, but not enabled normally.

Kevin Loney

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet