Home » RDBMS Server » Security » how to setup audit trail
how to setup audit trail [message #69768] Mon, 04 March 2002 08:58 Go to next message
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 Go to previous message
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
Previous Topic: how do i get what are the roles assigned to a user
Next Topic: Security - Public Objects
Goto Forum:
  


Current Time: Fri Dec 09 03:46:04 CST 2022