When working with Integration Services, you must manage access for three types of users:
Integration Services users who can access OLAP models and metaoutlines stored in OLAP Metadata Catalogs. (Integration Services users are the database users defined in the data source that contains the OLAP Metadata Catalog that you are using.)
Essbase users who can access the Essbase database that you create from a metaoutline
Source database and data warehouse users who can access the tables and views in the specified source database or data warehouse
Use the tools provided with each data source to manage each set of users. Consult the data source documentation if you are not sure how to perform any of the following tasks: