| |
 |
|
Oracle Tips by Burleson |
Chapter 8 General Oracle Auditing
-
Create Temp Table. As user SYS, create
the table aud_temp from the original table as shown in the following
query. While doing this, it may also be prudent to increase the
storage parameters. However, since we have already created the
tablespace as Locally Managed with Automatic Allocation of Segments,
this action (the changes in storage) is not required for databases
created with 9i and above.
create
table auditor.aud_temp
tablespace audit_data
as
select * from aud$
/
-
Rename. As user AUDITOR, rename the
table to the appropriate value using the following statement:
rename
aud_temp to aud$
/
-
Create the Index. As user AUDITOR,
create the index on the table.
create
index i_aud1
on aud$ (sessionid, ses$tid)
tablespace audit_indx
/
Again, the storage clause is not required
if the ASSM mode and LMT are selected in the tablespace
AUDIT_INDX.
-
Open the database. Remove the
database from RESTRICTED mode.
Now the table aud$ will be under the AUDITOR
schema and will be in tablespace AUDIT_DATA. The index will be in
AUDIT_INDX. The growth can be handled easily in this set up and it
will be easier to archive and purge data from this table.
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
|
|
