Add column-level security constraints

Pentaho Metadata Editor

Part Number
You must have a connection to a data source in Metadata Editor and have one or more tables selected.
Perform the following steps to add user-based or role-based restrictions to your data source.
  1. In the left pane, right-click the table or column you want to modify, then click Edit from the context menu.
    The Physical Table Properties dialog box appears.
  2. Click Add Property above the Available field in the middle of the screen.
    The Add New Property dialog box appears.
  3. Select Metadata Security, then click OK.
  4. Click the new Metadata Security item in the General category.
  5. Click the Plus Sign icon next to the Selected Users/Groups field in the right pane.
    A list of users and/or roles (depending on what you selected when configuring the security service earlier) appears.
  6. Select the user or role in the Available list, and then click the Right Arrow in the middle of the window to assign permissions.
    The user or role moves from the Available list on the left to the Assigned list on the right.
  7. Repeat this process for other users or roles you want to assign metadata permissions to, then click OK.
  8. Change any other relevant metadata options, then click OK to return to the Metadata Editor main window.
  9. When you are finished, save the metadata configuration as a domain using the Save As button, then publish it to the Pentaho Server as an XMI schema by selecting Publish from the File menu.