Accessing the OLAP Catalog

To create OLAP metadata, you must be able to log into your database with credentials that have been granted the OLAP_DBA role. The OLAP Catalog, consisting of both CWM and CWM2 metadata, is owned by the OLAPSYS user.

The OLAP_DBA role has system privileges associated with it, such as the ability to create and drop tables, indexes, and dimensions. For a list of these privileges, follow these steps:

1. Log into your database through Oracle Enterprise Manager.
2. Expand the Security branch.
3. Choose OLAP_DBA.
4. Display the Role and System Privileges pages.

If you have the system DBA role, then you also have the OLAP_DBA role. You must also have the CONNECT role.

Note: To view existing metadata, you only need the CONNECT and SELECT_CATALOG_ROLE roles.