Viewing Permissions for OLAP Models

Information about the permissions that are set for OLAP models and metaoutlines is stored in OLAP Metadata Catalog. View this information by selecting the appropriate columns from tables in OLAP Metadata Catalog.

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

MODEL_ID: a system-generated reference number.
MODEL_NAME: the name of the OLAP model; for example, TBC Model.
MODEL_DESCRIPTION: a description of the OLAP model. If you do not enter a description when you save the model, this column is blank.
MODEL_DATA_SOURCE: the name of the Open Database Connectivity (ODBC) data source on which the OLAP model is based; for example, TBC.
MODEL_OWNER: the login name of the OLAP model owner; for example, sa. The login name is specified in the data source that contains the OLAP Metadata Catalog.
MODEL_ACCESS_CODE: a reference number that indicates what level of access users, other than the owner, have to the OLAP model.
- The number 0 represents no permissions—other users can neither read nor write to the OLAP model.
- The number 1 represents read access—other users can read the OLAP model but cannot write to it.
- The number 2 represents read and write access—other users can both read and write to the OLAP model; this is the default.

To view access permissions for all OLAP models in OLAP Metadata Catalog:

Issue the following SELECT statement in the OLAP Metadata Catalog database, using the tools for the data source.
```
SELECT MODEL_NAME,MODEL_OWNER,MODEL_ACCESS_CODE
       FROM OM_INFO
```
View the results.
In the following example, TBC Model gives read and write permissions to other users (MODEL_ACCESS_CODE = 2). TBC_Mod_Archive gives read permissions to other users (MODEL_ACCESS_CODE = 1). TBC_Mod_Mine gives neither read nor write permissions to other users (MODEL_ACCESS_CODE = 0).
```
MODEL_NAME           MODEL_OWNER   MODEL_ACCESS_CODE
----------           -----------   -----------------
TBC Model            sa            2
TBC_Mod_Archive      sa            1
TBC_Mod_Mine         sa            0
(3 row(s) affected)
```