Can i truncate sys aud

In order to reduce size follow section 4. Post a Comment. Don't Worry, We Have Solution. Follow Us! Be Our Fan. Enter your email address:. Related Post People who read this post also read :.

Posted in: Database Auditing. Email This BlogThis! Share to Twitter Share to Facebook. The poster wanted to know about creating a procedure to periodically delete or truncate the contents and about creating that procedure as the user SYS. I answered with quite a log post detailing the issues of privileges and also showing a short example if creating a procedure as a user that has had its privileges removed later so it cannot be logged in with and then calling that procedure from another user to encapsulate the privilege.

You can read my post by clicking "more". If you want to allow another user to be able to delete the records from the SYS. All rights reserved.

This is a security risk as it would allow the user with the privilege to delete any table. Generally granting any privilege with the keyword ANY is a security risk. If you want to allow the user to be able to truncate a table owned by another user SYS. Truncating is much faster than deleting but you should consider the risk of the privilege needed as well. Then create your procedure as this user and grant execute on it to the user that will truncate the SYS. That way you hide the privilege from the user needing to do the delete.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications. Oracle technology is changing and we strive to update our BC Oracle support information. If you find an error or have a suggestion for improving our content, we would appreciate your feedback.

Just e-mail: and include the URL for the page. All rights reserved by Burleson. Take these recommended steps to truncate the audit trail: 1. Truncate the SYS. Insert records from the temporary table back into SYS.