| |
 |
|
Oracle Tips by Burleson |
Chapter 8 General Oracle Auditing
archive_audit_2.sh
--**********************************************
--
-- Copyright © 2003 by Rampant TechPress Inc.
--
-- Free for non-commercial use.
-- For commercial licensing, e-mail info@rampant.cc
--
-- *********************************************
# -------------------------------------------------------
# Filename : archive_audit_2.sh
# Description : Second part of the AUD$ archival and
# purge process.
# Parameters : 1. 2-digit Year of the archival process
# 2. 2-digit Month of the process
# Assumption : A file .sys_passwd in this directory
# containing the password of SYS.
# Important:
# Change the variables AUDIT_TS_NAME, AUDIT_INDEX_TS
# and ARC_FILE_SYSTEM, SYS_PASSWORD to suit to
# your site.
# -------------------------------------------------------
#
# Site dependent variables
AUDIT_TS_NAME=SYSTEM
AUDIT_INDEX_TS=SYSTEM
ARC_FILE_SYSTEM=/u200
SYS_PASSWORD=manager
#
ARC_YEAR=$1
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
|
|
