Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Audit Trace

384655Mar 18 2003 — edited Mar 19 2003

Hi,
i want to trace, for some users, what time they logon, from which machine, which oracle and os user, which program, how long they stay connect and more important what transactions they issue (so for example if the modify data or the before and after image or what they modified).
I have seen that from the listener.log i have the sid to which user connect, which program he uses, from what machine. But here i don't see the oracle user, the transaction issued and modifications of db.
Is there a way to implement this?
Thanks
Tarek

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 16 2003

Added on Mar 18 2003

#general-database-discussions

2 comments

232 views