Example - Defining Member 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
Continuing with the SampleSchema TBI_PANPROVIDER example from Defining Level Security. A user with the TBI_PANPROVIDER role is restricted from drill down access to levels below Product Department for the Product dimension’s Products hierarchy. This example demonstrates how to restrict access to the [Food] and [Non-Consumable] members of the Product Family level for the TBI_PANPROVIDER role.
  1. Select the TBI_PANPROVIDER role.
  2. In the Permissions box, expand the permissions for the Sales and Employees cube and for the Product dimension.
  3. Click the Products hierarchy.
  4. Select Top Level for the Product Family Level Name, and click Create. The Member Security Dialog box appears.
  5. Select [Food] and [Non-Consumable] in the Members matching filter box, and click the right arrow to move them to the Access to these members is box.
  6. Click Deny.


  7. Click OK. The TBI_PANPROVIDER role can only access [Product].[Drink] and its children. The Clear button for the Product Family level is now enabled in the Schema Element Properties View.