Re: Question about truncate the audit (aud$)

Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1095648966.158220_at_yasure>...
> cschang wrote:
> > I activated the audit under the sys and altered its tablespace out of
> > system and put it into a user schema tablespace. However, according to
> > the principle, I should periodically store the content to another place
> > (out of system ). I believe I can write a procedure under the sys to
> > copy the content to other user?s table and TRUNCATE out the content.
> > Although many previous newsgroup articles suggest to grant the execute
> > privilege to another user to run the procedure. My question is: is that
> > still a bad practice to create a procedure (an object) under the sys
> > which is from the Oracle to define the system and is not supposed to be
> > modified? ( I remembered one of the previous newsgroup articles
> > mentioned about such principle). My system is 8.1.7 on NT 4. Thanks.
> >
> > C Chang
>
> Never, ever, for any reason write anything as SYS. There is no reason
> to and you shouldn't. It has always been a bad practice and remains so.

So then, how can I clean out the aud$ table periodically without creating a procedure under SYS? Thanks.

C Chang Received on Mon Sep 20 2004 - 04:57:04 CDT