OraFAQ Forum: Forms » Automatic logout

Home » Developer & Programmer » Forms » Automatic logout (forms 6i and oracle 10g )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Re: Automatic logout [message #451066 is a reply to message #450930]

Mon, 12 April 2010 05:14

tamzidulamin
Messages: 132
Registered: October 2009
Location: Dhaka

Senior Member

Dear,

U can try with BEFORE & AFTER LOGON database trigger.

Regards
Tamzidul Amin.

Report message to a moderator

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

Report message to a moderator

Re: Automatic logout [message #451165 is a reply to message #451154]

Mon, 12 April 2010 14:30

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I'm sure your users will be thrilled when you suddenly log them out in the middle of important job they do at the moment.

Report message to a moderator

Re: Automatic logout [message #451188 is a reply to message #450930]

Tue, 13 April 2010 00:44

mdsohail10
Messages: 13
Registered: October 2009
Location: Bangladesh

Junior Member

try with this http://siebelunleashed.com/automatic-logout-from-siebel-application/

Report message to a moderator

Re: Automatic logout [message #451192 is a reply to message #451188]

Tue, 13 April 2010 00:55

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

What does Siebel have to do with Forms? I might be very wrong, but - no code at the page you posted is valid in Forms. Syntax is different. So, how would it work?

Anyway: timer is capable of checking whether it is 5 PM and, hopefully, perform EXIT_FORM (in WHEN-TIMER-EXPIRED trigger).

WHEN-NEW-FORM-INSTANCE trigger can check whether it is past 5 PM and EXIT_FORM, if necessary.

Report message to a moderator

Re: Automatic logout [message #451307 is a reply to message #451192]

Tue, 13 April 2010 13:21

ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

Quote:

I'm sure your users will be thrilled when you suddenly log them out in the middle of important job they do at the moment.

Well said,
@ OP think twice regarding this...
And answer Littlefoot Statement...
Is that time runs at server side or client side ?

And more over what will you do
if your requirement is based on client machine time ?

sriram Smile

Report message to a moderator

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

Report message to a moderator

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.

Report message to a moderator

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

Report message to a moderator

Previous Topic:	FRM-40202: Field must be entered (after the "standard" form had been modified)
Next Topic:	The application suspends..

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 22:42:18 CDT 2024