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="4eca26d082384710-39d1f33f-4a49461d-aa259d6c-6e3c1ca66ef82d0f8676c5c1"><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="8226e7959919bfef-66e98899-40734090-b0eda9ad-e481c242c45e32b9020acc4b"><ac:plain-text-body><![CDATA[

Engineering

[BC_DEPARTMENT]="Engineering"

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

...