Home » RDBMS Server » Security » enabling auditing!
enabling auditing! [message #56427] Fri, 28 March 2003 10:13 Go to next message
Anthony pena
Messages: 12
Registered: July 2002
Junior Member
Wath i have to do for anable auditing in oracle database.
Re: enabling auditing! [message #56429 is a reply to message #56427] Fri, 28 March 2003 11:37 Go to previous messageGo to next message
sai sreenivas jeedigunta
Messages: 370
Registered: November 2001
Senior Member
Hello,
Open init.ora and set the
AUDIT_TRAIL=DB
at the end of the file and restart the database.

sai
Re: enabling auditing! [message #56476 is a reply to message #56427] Wed, 02 April 2003 15:34 Go to previous message
Michel Bartov
Messages: 35
Registered: February 2003
Member
I just posted an integrated set of GUI tools to administer the Oracle database.
One of the functions is ‘Manage Database Auditing, under ‘Security’ that allows you to audit a specific user by statement or object and view all actions performed by the user.
You may need same help to get started, so feel free to contact me (michelbartov@yahoo.com). The link is http://www.barsoft.net/

You may also try this command: AUDIT ALL BY SCOTT BY SESSION;
(SCOTT is the user you want to audit)
Previous Topic: What's the impact, if I lock the account "scott"
Next Topic: audit user activities in database.
Goto Forum:
  


Current Time: Fri Mar 29 05:03:17 CDT 2024