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.

Adding Row Level

...

Security to a Pentaho Metadata Model

Row Level Security allows you to control the results that are returned in a query based on a user's security level.  You can specify which rows of data each User Role or User ID is allowed to retrieve from the database, based on some column of data, or combination of columns of data.

...

Role

Constraint

Admin

TRUE()

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="11e9d89754671675-14abf63a-4fe9499b-9b978b6a-f50c65d0446da5b01aa08f31"><ac:plain-text-body><![CDATA[

Sales

[BT_OFFICE.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="e25b9c748b21f6ed-2beea106-4b7b48a2-ba39b1a6-d54671f80c3c91e05571d1c8"><ac:plain-text-body><![CDATA[

Engineering

[BT_OFFICE.BC_DEPARTMENT]="Engineering"

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

...