Re: Restricting access to Oracle database to only Oracle Forms

From: Kenneth D Atkins <Kenneth.D.Atkins_at_tek.com>
Date: Tue, 21 Feb 1995 07:13:32 GMT
Message-ID: <Kenneth.D.Atkins.3.00774ABA_at_tek.com>

You could setup a database role with a password, give it the appropriate access to your application and hard code the password into your application's startup form. There is a discussion and example of this in appendix J of the Oracle*Forms reference manual.

---

Kenneth Atkins
Financial Data Systems Incorporated
Kenneth.D.Atkins_at_tek.com

---

In article <3i6hehINN57u_at_yellowstone.cis.ohio-state.edu> patel_at_cis.ohio-state.edu (kant c patel) writes:>From: patel_at_cis.ohio-state.edu (kant c patel)>Subject: Restricting access to Oracle database to only Oracle Forms>Date: 18 Feb 1995 23:29:05 -0500

>Hi,
 

>I have an Oracle7 server running on a SunSparc 10, and the client software
>runs on PCs & Macs (Oracle Forms & Databrowser). Now, the problem is that I
>would like to restrict access to the database through forms & browser only,
>and not allow the users to directly work on the database using other Oracle
>tools, like, Sqlplus, etc. Is there some way of restricting the tools that
>a user can use to connect to the server (by setting some entries in a table
>at the server, or something like that) ? The reason this is required to be
>done is that we need an additional level of security in the system (in
>addition to the role mechanism), since this is a medical system & lot of
>legal issues are involved.
 

>Thanks in advance,
 

>Kant.
Received on Tue Feb 21 1995 - 08:13:32 CET