SQL Language Guide : 8. SQL Statements : ALTER SECURITY_AUDIT : ALTER SECURITY_AUDIT Examples
 
Share this page                  
ALTER SECURITY_AUDIT Examples
The following examples allow the current security audit log to be switched and for security auditing to be suspended or resumed in the current installation:
1. Restart security auditing after it has been suspended.
ALTER SECURITY_AUDIT RESUME;
2. Restart auditing, switching to a new audit log.
Windows:
ALTER SECURITY_AUDIT RESTART
WITH AUDIT_LOG = 'd:\oping\ingres\files\audit.log'
Linux:
ALTER SECURITY_AUDIT RESTART
WITH AUDIT_LOG = /install/ingres/files/audit.3
3. Cause Vector to log events to the auditlog.7 file.
ALTER SECURITY_AUDIT
WITH AUDIT_LOG = '/auditdisk/auditlog.7';