| how to setup audit trail [message #69768] |
Mon, 04 March 2002 08:58  |
Helena
Messages: 42
Registered: February 2002
|
Member |
|
|
Hi all
I need to set up a audit trail for one user that I have for Oracle server 8170, 8160 and 8060... I need to be able to see what this user is doing from logging in and out.. can someone please help me with this... I have no clue as how to do it. ALso how to view the audit file.. sorry its a dummy question but I don't know how to do it
Thanks
Helena
|
|
|
|
| Re: how to setup audit trail [message #69778 is a reply to message #69768] |
Mon, 04 March 2002 19:04  |
Jim Willis
Messages: 11
Registered: October 2001
|
Junior Member |
|
|
I would suggest you view the documentation:
1) Oracle Sql Reference Guide - look at Auditing
2) Oracle Database Adminstration -
A. setting up your database for auditing
B. the audit statement
C. the audit trail
3) example from documentation on audit session command of 2 users:
AUDIT SESSION
BY scott, lori;
Auditing can generate alot of data, please read carefully your documentation before activating it.
It is very useful in alot of ways however you have to stay on top of it.
Hope this helps
Jim
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
