|
 |
|
Oracle Tips by Burleson |
Chapter 8 General Oracle Auditing
ARC_MONTH=$2
ARC_TS_NAME=AUD$ARC_YEAR$ARC_MONTH
ARC_TABLE_NAME=AUD$ARC_YEAR$ARC_MONTH
#
sqlplus /nolog << EOF1
whenever sqlerror exit
connect sys/$SYS_PASSWORD as sysdba
drop table AUD$
/
prompt AudArch: Dropped Table AUD$
REM
rename AUD_TEMP to AUD$
/
prompt AudArch: Renamed Table AUD_TEMP to AUD$
REM
create index i_aud1
on aud$ (sessionid, ses$tid)
tablespace $AUDIT_INDEX_TS
nologging
/
prompt AudArch: Created Index I_AUD1
REM
alter tablespace $ARC_TS_NAME readonly
/
prompt AudArch: Tablespace $ARC_TS_NAME made Read Only
EOF1
#
# Export the tablespace as transportable
# Note the password of SYS is passed from a file. This
# eliminates the chance of the password being visible
# by a ps –aef command
The above text is
an excerpt from
the bestselling book:
Oracle
Privacy Security Auditing.
It's only $39.95 and has an
download of working security scripts:
This is the only authoritative
book on Oracle Security, Oracle Privacy, and Oracle Auditing written
by two of the world’s leading Oracle Security experts.
This indispensable book is only $39.95 and has an
download of working security scripts:
http://rampant-books.com/book_2003_2_audit.htm
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|