Monday, March 3, 2008
Enable Audit Trail for Oracle 9i
Hi guys... sharing my knowledge as system analyst... instead of just writing on forex update... just let share what i do.. my fulltime job....
its been a while not writing at my blog.... forgive my broken english... ;)
Enabling Audit Trail in Oracle 9i.
Not most application come with audit trail function, as nowadays it a demand thing that people alwiz talk about... oracle offer flexibility and agility... to suit with current demand...
how does it work... first enable you initialization file with this paramater.
####Audit trail parameters########
audit_sys_operations=TRUE
audit_trail=OS #### option available OS DB or None #########
* OS - oracle will pass the audit trail report in event viewer
to make the job easy... i use option OS...
then connect to sql.
SQL>connect sys/@ as sysdba
SQL>audit all;
yosshh.. there you go... u see all the audit trail are log into window event viewer.
-this is for window user... ;)
orite mate till next time...
its been a while not writing at my blog.... forgive my broken english... ;)
Enabling Audit Trail in Oracle 9i.
Not most application come with audit trail function, as nowadays it a demand thing that people alwiz talk about... oracle offer flexibility and agility... to suit with current demand...
how does it work... first enable you initialization file with this paramater.
####Audit trail parameters########
audit_sys_operations=TRUE
audit_trail=OS #### option available OS DB or None #########
* OS - oracle will pass the audit trail report in event viewer
to make the job easy... i use option OS...
then connect to sql.
SQL>connect sys/
SQL>audit all;
yosshh.. there you go... u see all the audit trail are log into window event viewer.
-this is for window user... ;)
orite mate till next time...
Subscribe to Posts [Atom]
