Re: Forms only

From: Lun Wing San (Oracle) <wslun_at_qrcsun.qrc.org>
Date: 1997/03/31
Message-ID: <33403AB2.229D@qrcsun.qrc.org>#1/1

Søren M. Olesen wrote:
>
> Hi
>
> Is there any way, that I can prevent a user from connecting to a
> database with anything else than Forms ??, I would very much like to
> prevent some users from using SQL+ and alike.

  You want to prevent the users from using SQL*Plus for security.   As a result, you can

  (1) all users are granted with the CREATE SESSION privilege only.
  (2) all users are granted a role that can manipulate the data in Forms.
  (3) All forms are changed to the role mentioned in (2) by using SET_ROLE of 

DBMS_SESSION when new-form-instance trigger.   (4) All users are disabled to use SET_ROLE in SQL*Plus by adding entries in PRODUCT_USER_PROFILE.

---
Name   : Lun Wing San (Certified Oracle Database Administrator)

Title  : Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841

This posting represents the personal opinions of the author. It is not the
official opinion or policy of the author's employer. Warranty expired when you
opened this article and I will not be responsible for its contents or use.

Received on Mon Mar 31 1997 - 00:00:00 CST