Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Column-level security in Metadata Editor

  1. #1

    Default Column-level security in Metadata Editor

    Hi,

    I am trying to implement column-level security in Pentaho Metadata Editor.

    My requirement:
    I have created a model and then a business view. I have five columns added in the view. I publish this to server. When i say new report, i see the model and the categories inside it. Now, suppose i want to hide a particular column to a particular user, how can i do this?

    I want this kind of column-level security. Is there anyway to implement this?

    Any kind of ideas or suggestions would be of great help.

    Thanks,

    Ankit.

  2. #2
    Join Date
    Nov 2010
    Posts
    19

  3. #3
    Join Date
    Feb 2013
    Posts
    530

    Default Column level security in Pentaho metadata Editor. don't display specified columns.

    Hi ...

    What I have done ?
    I've designed a business model using two tables and published to the server and created a report using this business model.
    I've used joe and suzy users for to display different columns. let's say
    I created A B C D columns.
    given privileges to print all four columns to joe and and given privileges to C and D columns for suzy.(i.e, given meta data security options for hiding A and B columns for suzy user and selected the hide for this user)
    Again published to the server ..

    What my output is ?
    I've preview of report with A B C D columns for joe user.
    and at the same time I've seen preview in another browser for suzy user and still it is giving A B C D columns with no data for A and B columns and displaying data for C and D columns . ..

    What I want is ?
    I just want to print C and D columns for suzy user..

    Any help would be appreciated... Thanks in Advance

  4. #4

    Default I working with this too

    Quote Originally Posted by sadakar View Post
    Hi ...

    What I have done ?
    I've designed a business model using two tables and published to the server and created a report using this business model.
    I've used joe and suzy users for to display different columns. let's say
    I created A B C D columns.
    given privileges to print all four columns to joe and and given privileges to C and D columns for suzy.(i.e, given meta data security options for hiding A and B columns for suzy user and selected the hide for this user)
    Again published to the server ..

    What my output is ?
    I've preview of report with A B C D columns for joe user.
    and at the same time I've seen preview in another browser for suzy user and still it is giving A B C D columns with no data for A and B columns and displaying data for C and D columns . ..

    What I want is ?
    I just want to print C and D columns for suzy user..

    Any help would be appreciated... Thanks in Advance
    I put MetaData Security in the Column A. And I add user1 user2. I quit all the privileges in user1 and in report adhoc it works correctly but in report viewer not. I put a thread in the forum but nobody say anything.

    Have you resolved the problem?

    Thanks for advance.

Tags for this Thread

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.