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
Received on Sun Sep 19 2004 - 19:59:37 CDT
