RE: Oracle Session commands

From: Allen, Brandon <>
Date: Tue, 6 Dec 2011 16:29:24 +0000
Message-ID: <A250F0C68C23514CA9F3DF63D60EE10E091564_at_onews31>

You might also be able to get what you want from regular auditing if you set the parameter audit_trail=db,extended and then turn on auditing with a statement like this:

audit select table, insert table, update table, delete table [by <username>] by access;


-----Original Message-----
From: [] On Behalf Of Remigiusz Sokolowski

You could use FGA to audit

06.12.2011 15:50, Terrian, Thomas J DLA CTR TRANSACTION SERVICES

> Is there any view in Oracle that records all of the commands that came
> from a session?

Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.

Received on Tue Dec 06 2011 - 10:29:24 CST

Original text of this message