Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » user auditing (solaris 10 - Oracle Database 11g - Oracle Forms and Reports Services 10g)
user auditing [message #444077] Thu, 18 February 2010 11:13 Go to next message
Messages: 232
Registered: November 2006
Senior Member

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 Go to previous message
Messages: 92
Registered: September 2008
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.

Previous Topic: Uploading Files
Next Topic: Ways of publishing Oracle data
Goto Forum:

Current Time: Mon May 27 22:19:14 CDT 2024