Application Page Auditing
988417Jan 31 2013 — edited Feb 7 2013Hi guys
I am pretty new to Oracle Application Express, but have experience in SQL (as a student).
I have created an application. I would like to audit which users visit which pages (tabs). I have tested using the Apex_Activity_Log features built-in but I would like to create something myself...
Reading and understanding what I know, I was going to use a trigger. I don't think this would be suitable. Firstly, not all pages have tables; for example the welcome page has a simple HTML region, welcoming the user to the application (there are a number of pages similar to this). Secondly, I am not interested in what the user has done on the page, rather what tabs the user has visited and when.
I am struggling to understand how this will work, or if it's even possible. Many of the auditing examples I have researched focus on trigger table audits.
Any help and guidance would be fantastic.
Thanks
Matt.