Home » SQL & PL/SQL » SQL & PL/SQL » Database Auditing
Database Auditing [message #198092] Sat, 14 October 2006 13:29 Go to next message
rampratap
Messages: 50
Registered: November 2004
Location: New Delhi
Member

Hi Friends,

I want to have a database audit.

I set my init.ora
audit_trail = DB
restarted the system
connected as sys/ as sysdba
executed the oracle_home/rdbms/admin/cataudit.sql
audit table
select * from aud$;
out put 0
another session connected to scott/tiger
create table xyz(num number);

in sys session
select * from aud$
o row selected



according to book ref this should work but no its not working
my oracle version is 9.0.1

can any body suggest some step.

Thanks,

RP Singh
Re: Database Auditing [message #198093 is a reply to message #198092] Sat, 14 October 2006 14:39 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You need to enable the specific audit options you want at this point (Setting Auditing Options).
Re: Database Auditing [message #198097 is a reply to message #198093] Sat, 14 October 2006 18:27 Go to previous messageGo to next message
rikfair
Messages: 22
Registered: October 2006
Location: UK
Junior Member
Hi
The following link may be of help. It demonstrates how to audit connections, but it can easily be adapted for whatever you want to audit.

http://www.astral-consultancy.co.uk/cgi-bin/hunbug/doco.cgi?11100

Razz
Re: Database Auditing [message #198293 is a reply to message #198093] Mon, 16 October 2006 08:25 Go to previous messageGo to next message
rampratap
Messages: 50
Registered: November 2004
Location: New Delhi
Member

Hi,

Sorry I have tried all these settings but still not working.

Can you please suggest step by step .

Thanks,

RP Singh
Re: Database Auditing [message #198324 is a reply to message #198293] Mon, 16 October 2006 10:39 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Can you post exactly what commands you tried?
Re: Database Auditing [message #198325 is a reply to message #198324] Mon, 16 October 2006 10:50 Go to previous messageGo to next message
rampratap
Messages: 50
Registered: November 2004
Location: New Delhi
Member

Hi,
step 1.
setting in init.ora
audit_trail = db
logged in as sysdba
executed $oracle_home/rdbms/admin/cataudit.sql
restrated the system

step 2.

Logged in as sysdba;
audit all by scott by access;
audit succeded
select * from aud$;
no row selected

another session opened with scott/tiger
select * from emp;
create table t1( a number);
update emp set sal = sal + 100;

step 3

again tried in sysdba login
select * from aud$;
no row selected
I tried select statement on
DBA_AUDIT_EXISTS
DBA_AUDIT_OBJECT
DBA_AUDIT_SESSION
DBA_AUDIT_STATEMENT
DBA_AUDIT_TRAIL
DBA_OBJ_AUDIT_OPTS
DBA_PRIV_AUDIT_OPTS
DBA_STMT_AUDIT_OPTS

but no entry for scott


Please correct me.

Thanks,
Re: Database Auditing [message #198349 is a reply to message #198325] Mon, 16 October 2006 13:32 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
I assume you are starting your database with the same init file that you are making the changes to ?

What is your output of: show parameter audit
Re: Database Auditing [message #198356 is a reply to message #198349] Mon, 16 October 2006 14:08 Go to previous message
rampratap
Messages: 50
Registered: November 2004
Location: New Delhi
Member

Hi Ebrian,

After checking parameters through OEM , deleting the spfile and creating spfile from pfile then its working.

Thanks

good exp.

Thanks again.

RP Singh
Previous Topic: LONG Select statement
Next Topic: 21/85 PL/SQL: ORA-00933: (merged 2 cross-posts)
Goto Forum:
  


Current Time: Sun Dec 04 19:11:10 CST 2016

Total time taken to generate the page: 0.07854 seconds