nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Row Level Security for Table or Data Set

Ravi Santhosh

Hello,
 
I have a requirement where the report is secured with the row level security i.e., lets consider my report displays customers and their respective countries in a table. Now a role is going to be created by the Acutate IHUb administrator with the Country name (USA -role name) and assign a user to that role. Now after publishing the report into Actuate IHUB server, if a user logged in and run the report, then he should be able to see only his countries customers records.
 
I tried placing the ACL expression for the Table element under Security option which is not working. Trying to place the column name in Data Set Row ACL Expression in Advanced Properties, but unable to succeed. I need to have Data to be secured.
 
Note: Role was given Security Read and Visible permissions in the Actuate IHub Server.
 
Can anyone help me on this?

Find more posts tagged with

Comments

JFreeman

Which version of the iHub are you utilizing?
 
What is the behavior you are receiving when it is not working?
Are you receiving a specific error?

Ravi Santhosh

Hello,
 
I dont know the version of the IHUB. But I tried using the data objects which is successful. But when i tried using the stand alone dataset and the table applying the ACL expression, its not working. Its not throwing any error. I have tested the Data security using the option View Report with Data Security while running the report, but not woking., displaying all records of customers.
 
Attached a report which has the ACL expression at table security option.

JFreeman

I do not see the report design attached.
 
Could you please attach your report design with the ACL expression in place on the table that isn't working?

Ravi Santhosh

Hello,
 
Sorry I forgot to attach the file. Here I am attaching the ACLExpressionReport.rptdesgin contains the ACL expression at Table's Security Option.
 
Thanks

JFreeman

Looking over your report design, it looks like you are missing the group to be associated with the ACL for Page Level Security.
 
I have modified your report to include a group on the table based on Country and modified the ACL on the table to still be the same expression of row["COUNTRY"] except it is now associated with the group I created.
 
Using this configuration, run the report by selecting View Report with Page Security and provide a country or countries, without quotes, separated with commas into the ACL box that appears before the report is run.
 
For Example: USA, Canada, UK
 
I have attached the modified report design for reference.