purge_audit

Purges old entries from the audit trail.

The function guarantees to keep data inserted at or after the specified timestamp and attempts to delete as many entries as possible inserted prior to the specified timestamp to reclaim as much storage space as possible. Note that there is no guarantee about how many entries will be deleted.

Available in a network database and requires the star$administrate role.

Parameters:

Name Optional Type Description
datetime$ Mandatory Timestamp The audit timestamp threshold.

Examples:

SELECT purge_audit('2017-01-01'); -- reclaims space from audit entries inserted prior to Jan 2017

Tips:

  • The star$audit view lists the current audit entries

 

Have more questions? Submit a request

Comments

Article is closed for comments.

Powered by Zendesk