reporttabledeny.properties

By default, this property holds a list of Security Identity Manager tables used by various Security Identity Manager components to store internal or configuration data that is inappropriate for a report. This file is used by IBM Security Identity Manager Server for Reporting Engine purposes..

The following table defines the properties that determine which information is not exposed in reports.

    tables
 

Holds a comma-separated list of all IBM Security Identity Manager database tables that are excluded from report production..

If a table is part of this property, the table and its columns are not in the Report Designer; a report cannot be designed on columns of this table. A user who wants to deny a specific database table from being used by the Report Designer can choose to add the table against the tables property.

Example.

    tables=JMSState, JMSStore, entity_column, column_report, report, synchronization_history, synchronization_lock, changelog, resources_synchronizations, NextValue, ListData, AUTH_KEY, ATTR_CHANGE, ACCT_CHANGE, LCR_INPROGRESS_TABLE, WORKFLOW_CALLBACK, POLICY_ANALYSIS, POLICY_ANALYSIS_ERROR, PO_TOPIC_TABLE, PO_NOTIFICATION_TABLE, BULK_DATA_SERVICE, MIGRATION_STATUS, SYNCH_POINT, COMPLIANCE_ALERT, PO_NOTIFICATION_HTMLBODY_TABLE, BULK_DATA_STORE, BULK_DATA_INDEX, MANUAL_SERVICE_RECON_ACCOUNTS, SCRIPT, ACTIVITY_LOCK
allowedRestrictedColumns
 

Allows IBM Security Identity Manager administrators to explicitly allow columns of restricted data types, to be used for designing and running custom reports. Such reports however work for IBM Security Identity Manager Administrators only. If a non-administrator attempts to run such reports, the user receives an AuthorizationException. By default, columns of the following restricted data types are not available when you design or run custom reports:

    BLOB, CLOB, BINARY, VARBINARY, LONGVARBINARY and LONGVARCHAR

The value of the property is a comma-separated list of <TABLE_NAME>.<COLUMN_NAME>. If this property is undefined, then none of the columns of the restricted data type is available for reporting.

Example (on a single line).

    allowedRestrictedColumns=ACTIVITY.RESULT_DETAIL, PROCESS.RESULT_DETAIL, PROCESSLOG.NEW_DATA

Parent topic: Supplemental property files