Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Default login and reconnect issue

639858Aug 5 2008 — edited Sep 11 2008
Hello 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

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 9 2008
Added on Aug 5 2008
6 comments
639 views