1 Reply Latest reply: Feb 4, 2013 2:36 AM by swesley_perth RSS

    Oracle APEX Fine Grained Auditit (FGA)

    988549
      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)
          swesley_perth
          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