RE: Oracle Session commands

  • From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
  • To: "remigiusz.sokolowski@xxxxxxxxxx" <remigiusz.sokolowski@xxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 6 Dec 2011 16:29:24 +0000

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;

Regards,
Brandon


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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.
--
http://www.freelists.org/webpage/oracle-l


Other related posts: