1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

How to audit select query results?

Discussion in 'SQL PL/SQL' started by splena, Dec 6, 2016.

  1. splena

    splena Starter

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    10
    Location:
    Austin, TX
    Hi,


    I need to setup auditing (or logging) for RESULTS of queries that are run by certain users against certain tables.

    For example, when they run some select statement against "patients" table I need to log all PatientID that were selected from this table. So if there were 100 records selected, there should be 100 "audit" records with patientID logged. Is this possible?

    Fine-grained auditing will result in one audit record with the text of the select statement. But how can I audit the actual result of a select query? It seems to me that it should be "select for each row" trigger for this that does not exist.



    I will appreciate any help.

    Thank you.
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,564
    Likes Received:
    362
    Trophy Points:
    1,430
    Location:
    Aurora, CO