KFAA30575-E

The aa....aa operation cannot be performed because the audit trail facility is disabled. <SQLSTATE: 52011>

aa....aa: Operation that could not be performed

• CREATE AUDIT: Defining an audit target

• DROP AUDIT: Deleting an audit target definition

• REVOKE AUDIT ADMIN: Revoking the audit admin privilege

• REVOKE AUDIT VIEWER: Revoking the audit viewer privilege

• audit trail search by using the system-defined function ADB_AUDITREAD: Searching for an audit trail by using the ADB_AUDITREAD function

S:

Ignores this SQL statement. Alternatively, the system invalidates this transaction.

Action:

Execute the adbaudittrail --start command to enable the audit trail facility. Then, retry the aa....aa operation.

If this message (aa....aa indicates REVOKE AUDIT ADMIN) is output when you attempt to revoke your audit admin privilege in order to stop using the audit trail facility, the operation failed for one of the following reasons:

• Another HADB user has the audit privilege.

• You have the audit viewer privilege.

In this case, use the following procedure:

1. Enable the audit trail facility.

2. Revoke the audit privilege of the other HADB user.

3. Revoke your audit viewer privilege.

4. Disable the audit trail facility.

5. Revoke your audit admin privilege.