• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1481
  • Last Modified:

Audit Trail on Oracle 8i 8.1.7

Dear All,

I have activated Oracle trail using the following steps :
1) Connect as Sys
2) Execute Catalog.sql Procedure
3) Execute CATAUDIT.SQL Procedure
4) Issue the command : Audit All; in order to Audit all DB activities

I have Executed many SQL statements but can't find any records in SYS.AUD$ view !!!

Are there any missing actions should be taken in order to make audit trail work


Thanks in advance
0
m_jundi
Asked:
m_jundi
  • 2
1 Solution
 
sapnamCommented:
I believe you have to add the audit_trail parameter in your init.ora file.

Try the following:

audit_trail=db

which will start logging in the SYS.aud$ table.

Another valid value is also audit_trail=os  

which will start logging in the operating system audit file, may not be what you want.
0
 
m_jundiAuthor Commented:
Many Thanks Sapnam for your reply, but the correct value is audit_trail=true

Now My DB start logging but I thought audit trial will give more clear data, What I need exactly what SQL & Stored procedures the users execute, I want to trace an action for a program in the DB , means which stored procedures run when this program executed. the program built in Powerbuilder and we don't have the source code.

Thanks
MAHMOUD
0
 
radja7Commented:
You do not need audit for this purposes.
Use V$SQLTEXT, V$SQL, V$OPEN_CURSOR
Join this with V$SESSION (SQL_HASH_VALUE, SQL_ADDRESS) to monitor current sql activity by sessions

0
 
radja7Commented:
0

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now