Home
Security
You can secure your Informix® database server and the data that is stored in your Informix databases. You can encrypt data, secure connections, control user privileges and access, and audit data security.
Security in HCL Informix®
The Informix® Security Guide documents methods for keeping your data secure by preventing unauthorized viewing and altering of data or database objects, including how to use the secure-auditing facility of the database server.
Auditing data security
Audit administration
Auditing setup
Setting the error mode

Security
You can secure your Informix® database server and the data that is stored in your Informix databases. You can encrypt data, secure connections, control user privileges and access, and audit data security.
- Security in HCL Informix®
  The Informix® Security Guide documents methods for keeping your data secure by preventing unauthorized viewing and altering of data or database objects, including how to use the secure-auditing facility of the database server.
  - Securing data
  - Auditing data security
    - Overview of auditing with the Informix® secure auditing facility
    - Audit administration
      - Administrative roles and role separation
      - Auditing setup
        Setting up the default and global masks
        Specifying a directory for the audit trail (UNIX™)
        Setting the error mode
        Setting the audit level
        Setting up selective row-level auditing
        Auditing can be configured so that row-level events of only selected tables are recorded in the audit trail. Selective row-level auditing can compact audit records so that they are more manageable and potentially improve database server performance.
        Activating auditing
      - Audit mask maintenance
      - Audit configuration maintenance
    - Audit analysis
    - The onaudit utility
      Use the onaudit utility to manage audit masks and auditing configuration.
    - The onshowaudit utility
      Use the onshowaudit utility to view the audit information from an existing audit trail. You can use this command to extract information for a particular user, database server, or both, making it possible to isolate a particular subset of data from a potentially large audit trail.
    - Audit event codes and fields
      The secure-auditing facility audits certain database server events.
    - The ADTCFG file

Setting the error mode

As Overview of auditing with the Informix secure auditing facility describes, the database server has three actions that it can perform if an error occurs when writing to the audit trail: a continue-error mode, and two levels of severity of halt-error mode. Be sure that you understand the implications of each error mode before you select one.

Use the onaudit utility or the ADTCFG file to set the error mode. For the onaudit syntax, see The onaudit utility: Configure audit masks. For the ADTERR configuration parameter, see The ADTCFG file.

The following onaudit command sets the error mode to continue. The database server processes the thread and notes the error in the message log.

onaudit -e 0

The following command sets the error mode to the most severe level of halt, in which the database server shuts down:

onaudit -e 3