sysaudit

For each defined audit mask (that is, for each username), the sysaudit table contains flags that represent the database events that generate audit records. The success and failure columns represent the bitmasks that compose the audit masks. If a bit is set in both the success the and failure columns, the corresponding event generates an audit record whether or not the event succeeded.

You must be user informix or user root on UNIX or a member of the Informix-Admin group on Windows to retrieve information from the sysaudit table.

Use the onaudit utility to list or modify an audit mask. For information about onaudit and auditing, see your IBM® Informix® Security Guide.
Column Type Description
username char(32) Name of the mask
succ1 integer Bitmask of the audit mask for success
succ2 integer Bitmask of the audit mask for success
succ3 integer Bitmask of the audit mask for success
succ4 integer Bitmask of the audit mask for success
succ5 integer Bitmask of the audit mask for success
fail1 integer Bitmask of the audit mask for failure
fail2 integer Bitmask of the audit mask for failure
fail3 integer Bitmask of the audit mask for failure
fail4 integer Bitmask of the audit mask for failure
fail5 integer Bitmask of the audit mask for failure

Copyright© 2019 HCL Technologies Limited