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="a56c42f52b78be37-f3d8bdc5-481845f2-9fcab935-b51ad470dd11a2bfd457f9d5"><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="baf9cd3dd60f4825-b6285f95-461842b9-a5f0b6f0-20c5e1b64b9754a12ae10689"><ac:plain-text-body><![CDATA[

Engineering

[BC_DEPARTMENT]="Engineering"

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

...