Automatic logout [message #450930] |
Sat, 10 April 2010 22:53 |
vikasg2006
Messages: 80 Registered: March 2006 Location: Dubai
|
Member |
|
|
Hi,
I want if user is working on forms application which is build in forms 6i with oracle 10g database , as soon as time reached to 5PM it automatically log off. and won't allowed to log in after 5 PM.
How to do that
|
|
|
|
Re: Automatic logout [message #451154 is a reply to message #451066] |
Mon, 12 April 2010 12:28 |
vikasg2006
Messages: 80 Registered: March 2006 Location: Dubai
|
Member |
|
|
Dear,
My requirement is different. before and after log on works only if you try to login at 5 pm or after that. But if you already login at 4 pm... I want to log out automatically as soon as clock reached to 5 pm
|
|
|
|
|
|
|
Re: Automatic logout [message #451437 is a reply to message #450930] |
Wed, 14 April 2010 10:59 |
vikasg2006
Messages: 80 Registered: March 2006 Location: Dubai
|
Member |
|
|
Well... No body is thrilling... My requirement was based upon server side timing else everyone can change its system time
@ Littlefoot. Thanks. your advice will solve my problem.
Actually Issue was in client company shift end at 4.30 but some people left there session on, due to that some time dead lock occurs for other users who came in night shift. For issuing this problem we plan to auto log off from oracle session after 5 pm
|
|
|
Re: Automatic logout [message #451438 is a reply to message #450930] |
Wed, 14 April 2010 11:02 |
cookiemonster
Messages: 13938 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
Do you mean deadlock - ORA-00060 - or do you just mean that they are getting resource busy errors or similar?
If it's the former then you've got a bug in the code that needs fixing. Otherwise it's not a deadlock just a normal lock.
|
|
|
Re: Automatic logout [message #451468 is a reply to message #451437] |
Thu, 15 April 2010 00:19 |
ammadahmed
Messages: 7 Registered: April 2010 Location: Pakistan
|
Junior Member |
|
|
Hi,
I want to add my one idea here.
1. Create one table called any name let suppose TBL_TIME (ID, DATE)
2. On the database side create one job that will run on everyday 5 o'clock. First it will insert one row in that table suppose (1, 15-APR-2010) and then it will kill all the session which are exist in v$session.
3. On the forms login screen if you have already trigger ON-LOGON then just add code in that trigger which will see in the TBL_TIME that record exist for today date or not. If record exists then system will not allow to login to the users. And the session which are already open being killed by the job.
I think it will help you.
-Ammad
|
|
|