user auditing [message #444077] |
Thu, 18 February 2010 11:13 |
dirish
Messages: 232 Registered: November 2006
|
Senior Member |
|
|
Hi,
I have Oracle Database 11g - Oracle Forms and Reports Services 10g installed on Solaris 10.
I want to audit all users accessing my application, especially those who are just browsing. Set up a timeout mechanism in Oracle for users who have already logged on the my application but have not been working for, say, 10 minutes.
Thank you
|
|
|
Re: user auditing [message #444730 is a reply to message #444077] |
Tue, 23 February 2010 15:19 |
dlwixon
Messages: 92 Registered: September 2008
|
Member |
|
|
Just create a table with application_name, user_name, start_time, and end_time
Create a block in your form for this table and it's fields.
When a user enters your form you can populate the application_name, user_name and start_time in a when-new-form-instance trigger.
When a user leaves your form, populate the end_time in the post-form trigger.
You can just create a report to show you the audit information you need from there.
|
|
|