OraFAQ Forum: Security » enabling auditing!

Home » RDBMS Server » Security » enabling auditing!

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

enabling auditing! [message #56427]

Fri, 28 March 2003 10:13

Anthony pena
Messages: 12
Registered: July 2002

Junior Member

Wath i have to do for anable auditing in oracle database.

Report message to a moderator

Re: enabling auditing! [message #56429 is a reply to message #56427]

Fri, 28 March 2003 11:37

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

Report message to a moderator

Re: enabling auditing! [message #56476 is a reply to message #56427]

Wed, 02 April 2003 15:34

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)

Report message to a moderator

Previous Topic:	What's the impact, if I lock the account "scott"
Next Topic:	audit user activities in database.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 23 16:29:35 CST 2025