Re: Restricting access to Oracle database to only Oracle Forms
Date: Mon, 20 Feb 1995 17:20:06 GMT
Message-ID: <D4B6tJ.H65_at_lanier.com>
In article <3i6hehINN57u_at_yellowstone.cis.ohio-state.edu>,
kant c patel <patel_at_cis.ohio-state.edu> wrote:
>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 ...
> [etc]
I may be off base here, but I think you are asking the wrong question. The functionality of an application (including any custom security measures) should be embedded in the application, not in the user interface. Forms, Sqlplus, etc are user interfaces. If your application is properly encapsulated within views and procedures, the user interface should only be doing SELECT statements and procedure calls. (Mind you, I haven't actually built an application this way, but this is the ideal.)
If you build your application this way, you should not care what user interface anyone uses.
Don
Donald E. Vick (dvick_at_lanier.com, dvick_at_crl.com) Voice: (404) 493-2194 Fax: (404) 493-2399 Received on Mon Feb 20 1995 - 18:20:06 CET