Skip Headers

Oracle9i OLAP User's Guide
Release 2 (

Part Number A95295-02
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page

Go to previous page Go to next page
View PDF

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 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.


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