Hitachi Vantara Pentaho Community Wiki
Child pages
  • 06. Adding Row Level Security to a Pentaho Metadata Model

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Within the Metadata Editor, select the model to add Row Level Security to, right click on the Model, and select "Edit...".

Panel

WARNING: Row Level Security is only in effect at the Model level.  Any data constraints defined below the Model Level, such in a Business Table or Business Column, is ignored and not used.

From the Model Properties dialog, select the General -> Data Constraints Property:
 
 By default, Row Level Security is not enabled.  There are two forms of Row Level Security in Pentaho Metadata, Global Constraint and Role Based Constraints.

...

Role

Constraint

Admin

TRUE()

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="801ae74a9582f6e6-dff4f907-40a84352-83b9adb1-3a377a39874ba85115c6143d"><ac:plain-text-body><![CDATA[

Sales

[BC_DEPARTMENT]="Sales"

]]></ac:plain-text-body></ac:structured-macro>

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="bb1f9b80186b51ad-684a8df6-4ab74e40-940da2e0-31b290dbdfd5709c234f0723"><ac:plain-text-body><![CDATA[

Engineering

[BC_DEPARTMENT]="Engineering"

]]></ac:plain-text-body></ac:structured-macro>

...