Default login and reconnect issue
639858Aug 5 2008 — edited Sep 11 2008Hello everyone ,
I'm using Forms9i, Oracle databse9i, XP as OS and IE6 as browser.
Problem
I'm having a college project some of the requirements are as follow:-
1. the application is used by many users having different level of authorization.
2. they may log in at same time or different.
3.the application make database connection just once (default login to database) at the first time when it is called
What i'm doing:-
i use to make database connection using the "user having full authorisation on tables" and provide the login screen to users as the first interface.(login to databe is done thru coding)
according to the the privilage the interface will be loaded(i used enable /disable of the controls for differnt privilage like hiding the table or query button which does not belong to that user )but have no idea about the rest of the problems
The Problem i'm facing:-
connecting database with the user having full control will make any security loop hole, (although i provided a login screen and used restriction from application by disabling the controls)
if it is used by more than 1 person then at each time it will reconnect to the database (is there any way to prevent it)
like java servlet use reusable commponet (servlet/jsp pages) does forms do the same
thanks
Edited by: Rainbow on Sep 11, 2008 4:27 PM