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.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Sun Sep 19 2004 - 21:54:55 CDT
