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="7ef645ec17c4404e-89f666a7-4ba54a2e-89f3a048-bb66a55adf66bc54d322baa1"><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="e7a2c8e4e6d91df7-4a8f2fd6-4a1849ae-90dab5e8-ddd7a38cfc42788f19365e9e"><ac:plain-text-body><![CDATA[

Engineering

[BC_DEPARTMENT]="Engineering"

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

...