[teiid-issues] [JBoss JIRA] (TEIID-1741) Record level audit trail in teiid log files

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-1741?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins resolved TEIID-1741.
-----------------------------------
         Assignee: Steven Hawkins
    Fix Version/s:     (was: Open To Community)
       Resolution: Done


Added a sandbox translator as another demonstration of what can be done with the delegating translator.

https://github.com/teiid/teiid/blob/master/connectors/sandbox/translator-logger/src/main/java/org/teiid/translator/logger/RecordLoggingExecutionFactory.java

It is only an example.  From the request here it looks like additional considerations are - not all results would need to be logged (only columns considered auditable - although that can be a somewhat problematic concept for a more complex pushdown query), what information to include from the execution context, etc.

> Record level audit trail in teiid log files
> -------------------------------------------
>
>                 Key: TEIID-1741
>                 URL: https://issues.jboss.org/browse/TEIID-1741
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Connector API, Query Engine
>            Reporter: Monika Ahuja
>            Assignee: Steven Hawkins
>             Fix For: 8.11
>
>
> In order to track the audit trail for patient identified information access, we would like to track the executed queries, results as well as the timestamps for each user's query and its result.  Essentially we need a report providing the list of Medical Record Numbers accessed by each user id and I think we can use the Logs to track that (unless you suggest a better way).



--
This message was sent by Atlassian JIRA
(v6.3.11#6341)