Viewing Permissions for Metaoutlines

OLAP Metadata Catalog stores information about the permissions set for OLAP models and metaoutlines. View this information by selecting the appropriate columns from tables in OLAP Metadata Catalog.

The MO_INFO table in OLAP Metadata Catalog contains information about metaoutlines, including the following columns which are relevant to permissions:

MO_ID: a system-generated reference number for the metaoutline.
MODEL_ID: a system-generated reference number for the OLAP model on which the metaoutline is based.
MO_NAME: the name of the metaoutline; for example, TBC Metaoutline.
MO_DESC: a description of the metaoutline. If you do not enter a description when you save the metaoutline, this column is blank.
MO_CHANGE_DATE: the date on which changes were last made to the metaoutline.
MO_OWNER: the login name of the metaoutline owner; for example, sa. The login name is specified in the database that contains the associated OLAP Metadata Catalog.
MO_ACCESS_CODE: a reference number that indicates what level of access users, other than the owner, have to the metaoutline.
- The number 0 represents no permissions—other users can neither read nor write to the metaoutline.
- The number 1 represents read access—other users can read the metaoutline but cannot write to it.
- The number 2 represents read and write access—other users can both read and write to the metaoutline; this setting is the default.

To determine the access permissions for all metaoutlines in OLAP Metadata Catalog:

Issue the following SELECT statement in the OLAP Metadata Catalog database, using the tools for the data source.
```
SELECT MO_NAME,MO_OWNER,MO_ACCESS_CODE
       FROM MO_INFO
```
View the results.
In the following example, TBC Metaoutline gives read and write permissions to other users (MO_ACCESS_CODE = 2). TBC_Archive gives read permissions to other users (MO_ACCESS_CODE = 1). TBC_Mine gives neither read nor write permissions to other users (MO_ACCESS_CODE = 0).
```
MO_NAME              MO_OWNER    MO_ACCESS_CODE
-------              --------    --------------
TBC Metaoutline      sa          2
TBC_Archive          sa          1
TBC_Mine             sa          0
(3 row(s) affected)
```