To create an OLAP Metadata Catalog, you must have permission to create tables in the database or have whatever similar access privileges are required by the RDBMS that you are using.
Microsoft SQL Server—The tables in a catalog are not accessible if they are created by a user that does not have db_owner privileges. |
To create an OLAP Metadata Catalog:
Create a database for OLAP Metadata Catalog tables using the applicable RDBMS utility.
Take one of the following actions:
Create an OLAP Metadata Catalog automatically by using Integration Services Console (see Creating or Upgrading OLAP Metadata Catalogs Automatically).
Create tables for the OLAP Metadata Catalog database by running SQL scripts (see Creating OLAP Metadata Catalogs Manually).