[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 425
  • Last Modified:

Report Builder 1.0

I am working on Report Builder 1.0 AdHoc Reporting tool and want to implement Security/ Entitlements on the Tables/ data that the users can access. I cannot use multiple logins. I have a table that has the UserID and the RegionID.

I want to restrict the users to data for only the region that they are entitled for and return the data to them through AdHoc Reporting. Anyway to build this security/ Entitlements is highly appreciated.
0
Rdichpally
Asked:
Rdichpally
1 Solution
 
mlmccCommented:
Are the users logging into the application?

How are you getting the user id for the one running the report?

Assuming you can use the UserID/Region table to link to the rest of the data just create a where clause like

UserLoggedIN = UseridTable.UserId

Link the regionid from the table to the rest of the tables and it should take care of the security

mlmcc
0
 
RdichpallyAuthor Commented:
Thanks
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now