ALTER SECURITY_AUDIT Examples

Was this helpful?

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';

Last modified date: 11/28/2023