Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: dynamic row level data security

  1. #1
    Join Date
    Oct 2010
    Posts
    19

    Default dynamic row level data security

    Hi,

    I would like to pass a parameter (e.g. from session attribute, or user roles) to Global Constraint of a business model. Is there a way to do this?

    Thanks.

  2. #2

    Default

    in global constraint

    IN( [BT_TABLENAME.BC_COLUMN_NAME_WHICH_CONTAINS_PENTAHO_USER_NAME];USER())

  3. #3
    Join Date
    Oct 2010
    Posts
    19

    Default

    Thanks for the response.

    We'd like to add data constraint by user groups. So we defined user roles, but all of our users have more than one roles. I noticed there is also a ROLE() function. However, I did not know what the return value of the function ROLE() is. Is it possible to single out one of the roles to use as a constraint filter?

    Thanks again.

  4. #4
    Join Date
    Oct 2006
    Posts
    817

    Default

    Maybe this:

    Code:
    IN("Admin"; ROLES())
    Found at:

    http://wiki.pentaho.com/display/Serv...Metadata+Model

  5. #5
    Join Date
    Oct 2010
    Posts
    19

    Default

    Thanks for your response.

    Our typical constraint will be like [BT_TABLE_NAME.BC_COLUMN_NAME]=FUNCTION(one of a roles);
    A user might have several roles, say "customer 1", "division 2", "group 3". Here only the customer is significant. So the actual
    constraint will be [BT_TABLE_NAME.BC_COLUMN_NAME]=1 (assume FUNCTION("customer 1") = 1).

    Is this possible?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.