Many thanks to all who replied !
-Original Message-
Sent: ? 06 ? 2003 22:00
To: Multiple recipients of list ORACLE-L
Audrey,
Are these direct connections or coming through JVM or some other middle tier
server where the userid cannot be discerned.
You can use the audit statement
Dear list !
I need to audit / log several activities of users
against the DB .
I need to trace a user's login/logout as well as
DML operations on certain
tables.
I understand that there are more than one way to
achieve these.
Could you please share your experiences / tricks on
the matter.
Thanks
I seem
to be drawing a blank on this one.
-Original Message-From: Andrey Bronfin
[mailto:[EMAIL PROTECTED]]Sent: Monday, January 06, 2003
8:19 AMTo: Multiple recipients of list ORACLE-LSubject:
audit user activities
Audrey,
Are these direct connections or coming through JVM or some other middle tier
server where the userid cannot be discerned.
You can use the audit statement for SQL statements to look at any of the
following:
specific SQL statements
only system priv statements
any statement issued by a