Oracle web application session timeout

Hello ,
    I have an oracle web application developed in  9i . How can i set up session timeout for the web application ?  The  client browser session should time out after 10 minutes of inactivity on the client side.
Is it something to be set up on the application server properties ? Or is it something to be done with the Oracle roles on the Database server side ?

Thank you.
oracletomAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
sdstuberConnect With a Mentor Commented:
With a profile limit of 10, the Oracle session will be ended after 10 minutes of inactivity.
So the next action on the forms would encounter an error that the session was gone and the user would have to log in again.
0
 
sdstuberCommented:
It's not in the roles, it's in the profiles.

Find out what profile your web app is logging in with ...

select profile from dba_users where username = 'YOUR-WEB-APP-USER'

Then alter that profile

ALTER PROFILE your-web-app-profile LIMIT IDLE_TIME 10
0
 
sdstuberCommented:
If you want the browser's page to timeout rather than the actual database session,
you'd have to put that into your application.  Some javascript/vbscript timer
if the page hasn't posted or performed some other activity in 10 minutes you would logout or shut the window down or whatever.
0
 
oracletomAuthor Commented:

I just want the the user to re-logon after , say 10 mins, of inactivity for security reasons.Can this be done by LIMIT IDLE_TIME 10 in the profile ?
The application is developed using Oracle forms, and i think i CAN'T  implement Javascript/Vbscript in Oracle forms ?
Thank you.
0
All Courses

From novice to tech pro — start learning today.