Product manual

GFI EventsManager 4 Managing Event Sources | 99
Screenshot 68: Oracle Server properties - Audit by Statements tab
7. Select Audit by Statements and configure the options described below:
Option Description
Statements Click Browseto launch a list of available Oracle statements. Select the Oracle statements to audit and
click OK.
NOTE: Amongst others, Oracle statements can be ALTER, CREATE and SELECT .
User Oracle enables you to audit statements for a specific user. Click browse button to launch a list of
available users. Select the user and click OK.
Options Select audit options:
By Access - Creates one audit log for each statement execution.
By Session - Creates one audit log per user and per schema object. A session is the time between
a connection and a disconnection to/from the database.
Success - Processes only successful audits.
Failure - Select option to process only failed audits. Oracle will create an audit log if an audit
fails to complete.
Both - Select option to process all audit logs.
Audit Choose this option to instruct the Oracle server to start auditing the server activities corresponding to
the selected parameters (such as users, statements, etc.)
Stop Audit Choose this option to instruct the Oracle server to stop auditing the server activities corresponding to
the selected parameters (such as users, statements, etc.)
Current
audited state-
ments
A list that displays all current Oracle audited statements.
Table 35: Oracle Server properties - Audit by Statements tab
8. Click Apply and OK.