IBM Informix connections
DataMasque masks IBM Informix tables in place.
Required privileges
A DataMasque connection for IBM Informix requires at least the following permissions:
CONNECTprivilege on the database. Informix does not grant this implicitly; it must be granted to the user (or toPUBLIC).RESOURCEprivilege on the database. DataMasque uses this to create the mapping and staging tables and sequences it requires during masking (CREATE TABLEandCREATE SEQUENCE).SELECTandUPDATEon each table to be masked.ALTERon each table to be masked. DataMasque uses this to manage constraints during masking (viaSET CONSTRAINTS).INDEXon each table to be masked. DataMasque uses this to recreate indexes during masking. Informix permitsDROP INDEXonly to the index owner or a user withDBA, so the connection user must own the masked tables' indexes (typically by connecting as the schema owner), or holdDBA.DELETEon each table targeted by atruncate_tabletask, 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:
The system catalog tables DataMasque reads during discovery (
systables,syscolumns,sysindexes,sysconstraints, andsysreferences) are readable by any user with theCONNECTprivilege; no explicit grants are required.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:
The default port for Informix connections is 9089. If no port is specified in the connection settings, DataMasque will use this default.
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
mask_unique_keytasks are not supported. Use theimitate_uniquemask instead.Subsetting is not supported.
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 |