This discussion is archived
1 Reply Latest reply: Feb 4, 2013 12:36 AM by scott.wesley RSS

Oracle APEX Fine Grained Auditit (FGA)

988549 Newbie
Currently Being Moderated
I am currently testing fine grained auditing against 1 database table.

The FGA audit table holds nearly all the information I require for auditing, but I am unable to link an audit record to the application and page where the DDL statement was executed.
For example, on DEMO_CUSTOMERS, if I update a customer on Page 2 and then query the table on Page 1, there is no unique field to link th FGA information with the APEX activity log as the FGA database session ID is constant for the authenticated user and the action timestamp in the APEX activity log does not go into enough detail to link records.

Is it possible to retrieve this information and if so how is it done?
  • 1. Re: Oracle APEX Fine Grained Auditit (FGA)
    scott.wesley Guru
    Currently Being Moderated
    I'm not overly familiar with FGA, but depending on how this is triggered, you can interrogate information using substitution variables.

    The following may be useful for your situation
    :APP_ID
    :APP_PAGE_ID
    :APP_USER

    Detailed. Note, you may need to use v('APP_ID') syntax
    http://docs.oracle.com/cd/E37097_01/doc/doc.42/e35125/concept_sub.htm#BEIIBAJD

    Scott
    blog: [url grassroots-oracle.com]grassroots-oracle.com
    twitter: [url twitter.com/swesley_perth]@swesley_perth

    -- please mark any useful posts as helpful or correct, in the end it helps us all

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points