DataMasque Portal

IBM Informix connections

DataMasque masks IBM Informix tables in place.

Required privileges

A DataMasque connection for IBM Informix requires at least the following permissions:

  • CONNECT privilege on the database. Informix does not grant this implicitly; it must be granted to the user (or to PUBLIC).
  • RESOURCE privilege on the database. DataMasque uses this to create the mapping and staging tables and sequences it requires during masking (CREATE TABLE and CREATE SEQUENCE).
  • SELECT and UPDATE on each table to be masked.
  • ALTER on each table to be masked. DataMasque uses this to manage constraints during masking (via SET CONSTRAINTS).
  • INDEX on each table to be masked. DataMasque uses this to recreate indexes during masking. Informix permits DROP INDEX only to the index owner or a user with DBA, so the connection user must own the masked tables' indexes (typically by connecting as the schema owner), or hold DBA.
  • DELETE on each table targeted by a truncate_table task, where truncation tasks are used.
GRANT CONNECT TO <user>;
GRANT RESOURCE TO <user>;

GRANT SELECT, UPDATE, ALTER, INDEX ON <table> TO <user>;

-- Required only where truncation tasks are used
GRANT DELETE ON <table> TO <user>;

Notes:

  1. The system catalog tables DataMasque reads during discovery (systables, syscolumns, sysindexes, sysconstraints, and sysreferences) are readable by any user with the CONNECT privilege; no explicit grants are required.

  2. Repeat the table-level grants for each table to be masked.

Connection parameters

For IBM Informix databases, the following field is optional:

Schema The name of the schema (table owner) that DataMasque will operate on. If not specified, the connection user's name will be used as the default schema.

Notes:

  1. The default port for Informix connections is 9089. If no port is specified in the connection settings, DataMasque will use this default.

  2. Informix folds unquoted identifiers to lower case. Specify schema, table, and column names in lower case unless they were created as quoted (delimited) identifiers.

Encrypted connections

By default DataMasque connects to Informix without TLS. The following fields change that:

Enable TLS Connects over TLS. The connection fails if the server does not support TLS. DataMasque does not write a warning for Informix connections.
IBM Informix Server Certificate A connection fileset used to verify the server's certificate. Optional. Upload it as a zip file containing the ca.pem Certificate Authority file, using IBM Informix SSL ZIP, as described in Upload IBM Db2 LUW and IBM Informix CA Certificates. Without one, the system trust store is used. The server certificate must be valid for the connection's Host value.
Minimum security mechanism The weakest login mechanism DataMasque accepts from the server. Default (any mechanism) and 3 (user ID and password) accept any mechanism, including a user ID and password sent in clear. 9 requires the credentials to be encrypted. 13 also requires every statement, parameter and result to be encrypted. The connection fails if the server offers nothing at that level or stronger.

Limitations

Unsupported key columns

Data Type Unsupported Format
text All
byte All
blob All
clob All
boolean All
decimal (fixed point) Precision >= 32
decimal (floating point) Precision >= 16
money Precision >= 32