- In Schema Tree View, expand the Security folder and select an available role. The settings for the selected role display in the Schema Element Properties pane.
-
In the Permissions pane, select a check box to grant access, and any underlying objects (dimensions, hierarchies, levels).
Check boxes can be in one of the following three states:-
Empty – Indicates no access to that schema element.In the figure below, the role TBI_PANPROVIDER has no access to the following:
- Warehouse and Sales cube
- Promotion dimension in Sales and Employees cube
- Yearly Income hierarchy in Customer dimension of the Sales and Employees cube
A role can have access to a dimension in one cube but be denied access to the same dimension in another cube.
-
Grey – Indicates partial access to that schema element.
The figure below shows that the role TBI_PANPROVIDER has partial access to the Customer dimension (all hierarchies except the Yearly Income hierarchy).
-
Checked – Indicates full access to that schema element, and all child elements.
In the figure below, the role TBI_PANPROVIDER has full access to the Product, Store, and Time dimensions, including all their hierarchies and levels.
-
Empty – Indicates no access to that schema element.
- Validate and publish the repository. Security policy changes do not take effect until the schema is published to the repository. See Save, Validate, Publish, and Transfer.