Example - Defining Cube Security - Teradata Schema Workbench

Teradata Schema Workbench User Guide

Product
Teradata Schema Workbench
Release Number
16.20
16.10
15.10
Published
June 2015
Language
English (United States)
Last Update
2018-05-25
dita:mapPath
gvf1512702977003.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-4106
Product Category
Teradata Tools and Utilities
  1. Open a cube schema.
  2. From the Schema Tree View, expand the Security folder, and select an available role. The Schema Element Properties View appears in the right pane.

    By default, the role has access to the entire schema.

    In the figure, the user selects TBI_PANPROVIDER role.

  3. Clear the check box for the Warehouse and Sales cube. The figure below shows the TBI_PANPROVIDER role has been restricted from accessing the Warehouse and Sales cube.