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:
- Log into your database through Oracle Enterprise Manager.
- Expand the Security branch.
- Choose OLAP_DBA.
- 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.
|
