When you connect to source databases, Integration Services Console displays all tables to which the source database user ID provides you access (SELECT permission).
For all source databases, if you have partial access to a table, Integration Server displays the whole table. In the OLAP model, Integration Server cannot filter, load data, or load members in a column for which you do not have SELECT permission.
For IBM DB2, if you do not have access (SELECT permission) to a table, you cannot view columns or use the table to build OLAP models. |
System performance can suffer if the username employed to access the RDBMS data source has SELECT permission to more tables than are used by Integration Services |
For security and administration, define access:
Create specific RDBMS user IDs for users who create OLAP models.
Create views of data and provide users who create OLAP models with access to the views rather than the original tables.
Set conditions so that users access only a subset of the view. See the documentation for your RDBMS or data warehouse.