8. SQL Statements : ALTER SECURITY_AUDIT : ALTER SECURITY_AUDIT Examples
 
Share this page                  
ALTER SECURITY_AUDIT 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'
UNIX:
ALTER SECURITY_AUDIT RESTART
WITH AUDIT_LOG = /install/ingres/files/audit.3
VMS:
ALTER SECURITY_AUDIT RESTART
WITH AUDIT_LOG = disk$7:[ingres.files]audit.3
3. Cause Ingres to log events to the auditlog.7 file.
ALTER SECURITY_AUDIT
WITH AUDIT_LOG = '/auditdisk/auditlog.7';