Securing data
You can secure data at the value level by creating security filters.
A security filter defines which users, groups, or roles have access to specific data values in a table. When the users work with dashboards, reports, or explorations that use the table, only the data that is included in the security filter is visible to them.
There are business reasons for restricting access to data at such low level of granularity. For example, you have confidential data that only specific users are allowed to see. Or, a table contains many records, and your users need only a subset of those records.
Before you begin
The schema metadata for the associated data server connections must be loaded, and you must have write permissions for the connections and their signons.
Tables that are based on typed-in SQL bypass security filters. To avoid potential security risks, specify the ibmcognos.typeinsqldisabled property on the data server connection that your data module is based on. If an attempt is made to create an SQL-based table after this property is specified, the table is not created. If this property is specified after an SQL-based table was created, the query execution is stopped. For more information, see Cognos-specific connection parameters.
About this task
This type of data security can be implemented only for data server sources.
Users who perform this task must belong to a role that has the Set data security feature enabled in the administration interface. Otherwise, the table context menus in the data module won't show the Set data security option that is needed to perform this task. For more information, see Customizing the user interface.