| |
 |
|
Oracle Tips by Burleson |
Chapter 8 General Oracle Auditing
datafile '$ARC_FILE_SYSTEM/${ARC_TS_NAME}_01.dbf'
size 10M
autoextend on next 10M
extent management local
uniform size 256K
/
REM
prompt AudArch: Created Tablespace $ARC_TS_NAME
create table $ARC_TABLE_NAME
tablespace $ARC_TS_NAME
nologging
as
select * from AUD$
SEE CODE
DEPOT FOR FULL SCRIPT
and
add_months(
to_date('$ARC_YEAR$ARC_MONTH',’RRMM'),1)
/
prompt AudArch: Created Table $ARC_TABLE_NAME
create table AUD_TEMP
tablespace $AUDIT_TS_NAME
nologging
as
select * from AUD$
SEE CODE
DEPOT FOR FULL SCRIPT
to_date('$ARC_YEAR$ARC_MONTH',’RRMM'),1)
/
prompt AudArch: Created Temporary AUD$ table
EOF1
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
|
|
